July 13th, 2003, 07:39 AM
connecting to sql server using visual basic
I am a recent graduate with a trial for a new job tomorrow, and need some guidance/help/code/examples to successfully connect to a sql server from visual basic 6.0. I have no trouble connecting to Access but no such luck with sql server.
Need hhheeellllppppp !!!!!!
P.S. Would also appreciate an example to access the data in a table once connected.
July 13th, 2003, 11:14 PM
DataConnection = "Provider=SQLOLEDB.1;Initial Catalog=;Data Source=;UID=;PWD=;Connect Timeout=15"
July 14th, 2003, 02:58 PM
Here is good site for developer. http://www.codeproject.com/
you can go find what you want. Don't be nervous, take it easy.
Hope it helps.