SQL7-DSN-Less connection help needed

[lloydanderson]

Hello,

I am trying to set up VB script in excel, using ActiveX 2.0
and have had no joy! Any helpful suggestions? I copied this off of MS

Option Explicit
' Declare object variables for the Connection and Recordset objects.
Private cnMrkseg As ADODB.Connection
Private rsMrkseg As ADODB.Recordset

Private Sub Worksheet_Activate()
' Instantiate the object.
Set cnMrkseg = New ADODB.Connection
' Instantiate the Recordset object, then set its properties.
Set rsMrkseg = New ADODB.Recordset
cnMrkseg.ConnectionString = _
"Provider=SQLOLEDB.1;Password=Market;" & _
"Persist Security Info=True;User ID=Market;" & _
"Initial Catalog=DailyMktSegnewSql;Data Source=Jdvproxy"
cnMrkseg.Open

Bombs with '3706' ADO could not find the specified provider

Lloyd

 

[drost]

Hi, Lloyd

What is the name of your Database? That's what would go in the "Initial Catalog" portion of your connection string.

I am guessing that DailyMktSegnewSql is a SQL statement?

drost

 

[lloydanderson]

Hi,

The database name is DailyMktSegnewSql (like to type)...

 

[drost]

Hi, Lloyd

It worked fine for me when I inserted information to my database. I did find this on the MS site that may be useful:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q197902

 

[lloydanderson]

Thanks for testing this for me - It may be a rights issue - I will need to read more on how to put an excel program on an web server.