OleDB to SQL Server

[ianrudge]

We are just experimenting with OLEDB and followed the instructions using SqlUDL

Set SqlUDL = 'Provider=SQLOLEDB.1;Password=xxxxxxx;Persist Security Info=True;User ID=auser;Initial Catalog=SEC;Data Source=BOttRIS'

We then SqlConnect( hSqlHandle ) but after a wait we get

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

[Kumuthini Ragavan]

Create an empty udl file on your desktop (a file with udl extention eg. test.udl). Double click on it and enter the details you provided in the set SqlUDL and test connect. If it connects then your application should connect. If it doesn't then there is a problem with the properties entered. Hope this helps. Kumuthini Ragavan

[ianrudge]

Thank you Kumuthini

However that isn't the cause of the problem. After walking through the code you must ensure that the constant SqlDatabase is null!