Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Sql connection string VB6
Name: Anthony Arde Date: March 8, 2005 at 02:32:39 Pacific OS: winxp pro sp2 CPU/Ram: 386mb ram p3 733
Comment:
OK im trying to connect my local machine to my local sql database in VB6 but the connection strings i`ve tried dont work, i have set ado 2.7 as a reference ,the sql service is running as server name "ANTHONYW" another c++ database program works with this set up, i just need the correct connection string for vb6, Please help, Thanks Ant.
Name: secrets Date: March 8, 2005 at 08:38:40 Pacific
Reply:
try this: dim cn As New ADODB.connection dim rs As New ADODB.Recordset 'To Opent the Connection If cn.state = 0 Then cn.Open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=yourdatabasenamehere;Data Source=." 'Put Your Database name as Initial Catalog
if you are running a single database server in your envoirnment then don't change "." at Datasource in connection string otherwise replace "." with your sqlserver name.
Summary: Hi, i`m having a problem using an html file to display my reports for my vb database program, does anyone know how i can make it so my .htm file can grab info from my sql database? please help thanks ...
Summary: Dear Friends, I have been using MS Access as the backend and presently I have planned to use SQL Server as the back end. The connecting string to MS ACCESS is cmd = "Driver={Microsoft Access Driver ...
Summary: Hi there, please can someone help me out, i`m really having a tough time tring to connect to my remote mysql DB, this is the connection string i`m using : Conn3 = "DRIVER={MySQL ODBC 3.51 Driver};SERV...
0 
