connectivity error using sql server

[muskan]

hello

I have written:

conn.connectionstring= "data source=VTECHS;database=abc;uid=hkjhkj;password=*** ;"
conn.open
But this line creating error .
Error is "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
".

Please tell me how to remove the error.

[jai80]

hello

I have written:

conn.connectionstring= "data source=VTECHS;database=abc;uid=hkjhkj;password=*** ;"
conn.open
But this line creating error .
Error is "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
".

Please tell me how to remove the error.

hi muskan,

conn.connectionstring= "data source=VTECHS;PROVIDER=SQLOLEDB;database=abc;uid=hkjhkj;password=***;"
conn.open

you wil have to specify the appropriate provider name. the above line uses sqloledb provider, and it says that sql server is the backend that will be used for the application. Use specific provider name according to the rdbms/dbms you will be using for your application (sql server,ms-access...)

gud luck!

cheers,
jai

[muskan]

hello,

Thanks for reply.

But still connection is not established
It giving the same error
I have written as:
conn.connectionstring="PROVIDER=SQLOLEDB;Data Source=VTECHS;database=abc;User ID=fggh;Password=*****;"


tell how to remove.
Thanks.

hi muskan,

conn.connectionstring= "data source=VTECHS;PROVIDER=SQLOLEDB;database=abc;uid=hkjhkj;password=***;"
conn.open

you wil have to specify the appropriate provider name. the above line uses sqloledb provider, and it says that sql server is the backend that will be used for the application. Use specific provider name according to the rdbms/dbms you will be using for your application (sql server,ms-access...)

gud luck!

cheers,
jai