RE: Php-mssql connection problems on Windows XP

2008-04-24 Thread Jerry Schwartz
>-Original Message- >From: Jerry Schwartz [mailto:[EMAIL PROTECTED] >Sent: Thursday, April 24, 2008 10:01 AM >To: 'Padiyath Sreekumaran'; mysql@lists.mysql.com >Subject: RE: Php-mssql connection problems on Windows XP > >When using odbc_connect, you don&

RE: Php-mssql connection problems on Windows XP

2008-04-24 Thread Jerry Schwartz
When using odbc_connect, you don't use the DSN you've previously created. You use the complete definition of the connection. Here's an example of connecting to an MS Access database: define('ODBC_CONNECT', 'DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=server\\a

Re: Php-mssql connection problems on Windows XP

2008-04-24 Thread Sebastian Mendel
Padiyath Sreekumaran schrieb: Hello Sebastian, Thanks for your mail. But I donot see any difference in my $username and yours except '("). what surprise, yes, thats it! you have to use no quotes at all (or doublequotes) around variables, RTMF is this case the one from PHP but what has thi

Re: Php-mssql connection problems on Windows XP

2008-04-24 Thread Sebastian Mendel
Padiyath Sreekumaran schrieb: I got the following error when I execute the previous script: Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '$username'., SQL state 28000 in SQLConnect in C:\xampplite\htdocs\scri