Unusual database connection to SQL (Access 2002). Help!

[Dennis]

I have a database connection as follows. It uses a named server and NT
(Windows logon) Authentication. It connects to a SQL server:

With dbconn
.Provider = "Microsoft.Access.OLEDB.10.0"
.Properties("Data Provider").Value = "SQLOLEDB"
.Properties("Data Source").Value = "xxx100in3"
.Properties("Initial Catalog").Value = "RegistrationDev"
.Properties("Integrated Security").Value = "SSPI"
.Open
End With

Now, I need to know two things:

- How to code this (if possible) to replace the named server ("xxx100in3")
with an IP address only

- Use SQL Server authentication instead of NT (logon) authentication

Any thoughts of insights would be greatly appreciated.

thanks!

 

[Alex Dybenko]

Hi,
you can just replace server name with IP, as for SQL Server authentication
you have to remove Integrated Security and add UID and PWD properties

Look here for more info:
http://alexdyb.blogspot.com/2004/12/forgot-how-to-write-connection-string.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com