Is there something wrong with the following:
sConn = "Provider=SQLOLEDB.1;"
sConn = sConn & "Data Source=GSVR\SQL2000;"
sConn = sConn & "Initial Catalog=DBAX2;"
sConn = sConn & "User ID=usrBob;Password=frustra
Set m_ds = CreateObject("rds.dataspac
Set m_df = m_ds.CreateObject("rdsserv
strsql = "SELECT fld1, fld2 FROM tblSomeTable"
Set rs1 = m_df.query(sConn, strsql)
I get an error on the last line:
Error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
The SQL SVR is on the same machine as the webservice.
I have tried various combinations. The SQL Server name is correct, it does exist, the username/pw is correct, the user has permissions on the DB....
I've tried both NT and the NT+SQL SVR security settings.
I've tried using IUSR_GSVR as the user.
I've tried using just the "SQL2000" part of the DB Name as shown in Enterprise Mgr....
I've tried other formats as far as the connection string goes...
Oh yeah - if I use a simple "DSN=AXDB2", it works. I wanted a DSN-less connection, though as I understand it's better from a performance point of view.
Any solutions come to mind?
Many thanks -