By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,632 Members | 1,340 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,632 IT Pros & Developers. It's quick & easy.

SQL Connection

P: 1
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.
Mar 19 '07 #1
Share this Question
Share on Google+
5 Replies


balid
P: 18
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.
Mar 19 '07 #2

Dököll
Expert 100+
P: 2,364
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
Mar 20 '07 #3

Dököll
Expert 100+
P: 2,364
Just pushing this forward in case you missed it, pravin1166 :-)
Mar 26 '07 #4

P: 5
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....
Mar 26 '07 #5

100+
P: 149
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
Mar 26 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.