SQL Connection

[pravin1166]

My operatting ststem is WinXP, VB 6.0, SQL Server Professional 2000. when i trying to access data on vb from SQL Server Pro 2000 i get error can't connect to SQL Server. can you tell me answer and send sample program for it.

[balid]

My operatting ststem is WinXP, VB 6.0, SQL Server Professional 2000. when i trying to access data on vb from SQL Server Pro 2000 i get error can't connect to SQL Server. can you tell me answer and send sample program for it.

You may get answers faster if you show what you currently have. You may or may not be close with what you have.

[Dököll]

That's great advice. Also, if you are using ODBC, you may need to look in your Data Source Administrator to see if SQL Server is listed there :-)

Good luck with the project.

Dököll

[Dököll]

Just pushing this forward in case you missed it, pravin1166 :-)

[higaonon]

My operatting ststem is WinXP, VB 6.0, SQL Server Professional 2000. when i trying to access data on vb from SQL Server Pro 2000 i get error can't connect to SQL Server. can you tell me answer and send sample program for it.

main_connection.Open "Provider=SQLOLEDB.1;User ID=user_id;Persist Security Info=False;Password=user_password;Intial Catalog=table_name;Data Source=server_name"

Set main_catalog= New ADOx.Catalog
main_catalog.ActiveConnection= main_connection

-----------------------------
And, check if your SQL SERVER is running....

[ansumansahu]

My operatting ststem is WinXP, VB 6.0, SQL Server Professional 2000. when i trying to access data on vb from SQL Server Pro 2000 i get error can't connect to SQL Server. can you tell me answer and send sample program for it.

What is the specific error that your are getting when you try to connect.

thanks
ansuman