Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

remote sql 2000 connection VB6

Comment:

this is my current connection string that i`m using to connect to my sql2000 db that my isp is hosting for me, Please can you help Thanks Ant Conn3.ConnectionString = "Provider=SQLOLEDB.1;" & "User Id=" & usrname & ";" & "Password=" & pass & ";" & "Persist Security Info=true;" & "Initial Catalog=POARDB;" & "Data Source=" & srvname Conn3.Open

Name: Chi Happens
Date: January 25, 2006 at 13:32:50 Pacific

Reply:

This is how I make a connection string to a SQL database: ConnectionString = "Provider=SQLOLEDB;Driver={SQL Server};Server=" & ServerName & ";Database=" & DatabaseName & ";uid=" & UserName & ";pwd=" & Password & ";" This works for all versions of ADO Hope this helps, Chi They mostly come at night...mostly.

0

DOS batch help (ipconfig ...

has this been done?

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: hi, Working on VB with sql7.0, on WinME. While trying to connect to sql, it's not connecting. Neither there is any error message. Some one please show me a way, AS HOW TO CONNECT VB6 WITH SQL DATABASE...

Summary: Hi, I'm an engineering Student. We work with Ms Sql server 2000 in our college labs to get familiar with database queries n so on. I wanted to Learn this at home more practically so i got a copy of ...

Summary: Is it possible to access SQl 2000 with vb6 using window authentication? if so How or what need to be done to set that up? ...