Friday, February 17, 2012

dbnetlib problem when connecting to sql server through vb6

hi,
I am getting this error message when trying to connect to sql server through vb-sqldmo
-2147467259 (80004005)
DEBNETLIB connection open connect() sql server not found.
please help me out of this problem.
vinod.Can u post your connection string here?|||this is the connection string:
note: this was working alright till yesterday since last two years.

ConStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Pharma;Data Source=" & lServerName & ";Connect Timeout=15"|||Originally posted by bvmantos
Can u post your connection string here?

this is it:

ConStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Pharma;Data Source=" & lServerName & ";Connect Timeout=15"|||have you tried both network libraries in your connection string?|||Originally posted by ms_sql_dba
have you tried both network libraries in your connection string?

please explain which libraries u r refererring to, i am using sqldmo.dll

No comments:

Post a Comment