SqlWindows 6.1 OLEDB to SqlServer

[rleffew]

I have installed SqlWindows 6.1 SP2 on Windows 7. I have SS 2008RE2 on my local machine. Trying to connect using OLEDB.

I have created a UDL file, contents of which are:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=SRDB;Data Source=GCRDEV-7PRO\SRHOMES

Two code snippets:

Code: Select all

Set SqlUDL = 'test.udl'
If SqlConnect(hSql)
   Call SalMessageBox('OK','Connected',  MB_Ok)

This one connects -- it works!

However, what I would like to do is put all of that in the code, so this snippet:

Code: Select all

Set SqlUDL = 'Provider=SQLOLEDB.1;Password=123456;Persist Security Info=True;User ID=sa;Initial Catalog=SRDB;Data Source=GCRDEV-7PRO\SRHOMES'
If SqlConnect(hSql)
   Call SalMessageBox('OK','Connected',  MB_Ok)
Else
   Call SalMessageBox('Bummer','ERROR', MB_Ok)

Does NOT work -- it returns: SQL Error: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I'm probably doing something stupid, any advise is appreciated.

Thanks,

Roy.

[UVS]

I use:
Set SqlUDL = 'Provider=SQLOLEDB;Data Source=' || strGlobalLocalServer || ';Initial Catalog=' || strServerName || ';Integrated Security=SSPI'

Works fine for me. Also take a look at the string after you have created it and make sure it reads correctly.

[markus.essmayr]

Hello,

your connection string contins a backslash character in the data source: "GCRDEV-7PRO\SRHOMES"
Ensure that you quote that: "GCRDEV-7PRO\\SRHOMES"

Max

[rleffew]

Thanks Max!

I knew I had to be doing something "stupid". Trying to save time in testing, I keyed in the whole string forgetting about the special character backslash!

Roy.

[markus.essmayr]

No problem!
I think that already happened to everybody of us.
Sometimes it just need's another pair of eyes to "see"!

Max