Re^2: connection issues to MS SQL Server

Yes.. sorry about not clarifying! $user is the database username and $password is the database password. I am not passing lsxo as my username but a different username. lsxo is my windows login username. I'm not sure which authentication the database instance is using..how do I find out? Thank you!

Comment on Re^2: connection issues to MS SQL Server

Replies are listed 'Best First'.
Re^3: connection issues to MS SQL Server by FloydATC (Deacon) on Aug 07, 2009 at 20:43 UTC
First, check the server configuration. You will most likely want to use mixed mode, unless there are special security concerns that dictate otherwise. Secondly, check the ODBC data source. I don't have much experience with using DBI against SQL Server, but I do know that incorrect settings in the ODBC data source will usually override whatever the application is trying to do. Hope this helps :-) -- Time flies when you don't know what you're doing	[reply]

Replies are listed 'Best First'.

Re^3: connection issues to MS SQL Server
by FloydATC (Deacon) on Aug 07, 2009 at 20:43 UTC

Secondly, check the ODBC data source. I don't have much experience with using DBI against SQL Server, but I do know that incorrect settings in the ODBC data source will usually override whatever the application is trying to do.

Hope this helps :-)

-- Time flies when you don't know what you're doing

[reply]