ODBC connections

[cmc]

Hi,

I'm trying to use PHP running on a shared linux server to access a remote MS SQL database using ODBC, but I'm having no luck.

I'm a little confused as to what a DSN is. Is it a file that is created on the database server? or one that is created on the webserver? or is it something I can create using PHP? If it's a file on the webserver, is it something I can add as a user on a shared server?

I've been trying to use a DSN-less connection with the following connection string:

DRIVER={SQL Server}; SERVER=servername.com; DATABASE=databasename; UID=username; PWD=password;

but I just get the following error:

Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect

So far, by searching the web for all the help out there, I haven't even been able to work out if I'm doing something wrong, or trying to attempt the impossible.

Does anyone here know if I should continue trying to persue this, or should I just give-up?

thanks,

henry

[gardnc]

Found this is a serach. Is it helpful?

Larry

---

I fighted with the "Data source name not found and no
default driver specified, SQL state IM002 in SQLConnect"
error for a while trying to connect via ODBC to a SQL Server
2000. Finally I found this workaround:

$cn = odbc_connect("Driver={SQL Server};Server=MyServer;Database=MyDatabase",
"MyUser","MyPassword")

Change "MyServer", "MyDatabase", "MyUser" and "MyPassword" to the right values.

I guess that adding the "Integrated Security=YES" will work too.

Regards,

Yvan Ecarri, MCDBA, MCSD

[cmc]

Thanks for that Larry.

I found that in my searching too. I'm glad it worked for him, but it doesn't help me any - I still get exactly the same error.

cheers,

henry

[stevesweetland]

did you ever fix this?