A
Andy_Acute
Guest
Can anyone point me in the right direction with creating the database connection?
I don't want to use a dsn, but rather a dsnless connection.
I'm not sure if this can be set up through Plesk!
My connection works fine locally, and i've changed it to suite the server name.
I'm using the following:
"Driver={SQL Server}; Server=myservername; Database=mydatabasename;"
Do i need to add the UID and PWD even though i'm using Windows Authentication? Although I think i have tried that already.
My web application is in Classic ASP.
I can connect to my database through RDP and SQL Server Management Studio and create Quiries fine.
I just can't connect my web application to my database through the web browser!
Any advice much appreciated.
Thanks in advance
Andy
I don't want to use a dsn, but rather a dsnless connection.
I'm not sure if this can be set up through Plesk!
My connection works fine locally, and i've changed it to suite the server name.
I'm using the following:
"Driver={SQL Server}; Server=myservername; Database=mydatabasename;"
Do i need to add the UID and PWD even though i'm using Windows Authentication? Although I think i have tried that already.
My web application is in Classic ASP.
I can connect to my database through RDP and SQL Server Management Studio and create Quiries fine.
I just can't connect my web application to my database through the web browser!
Any advice much appreciated.
Thanks in advance
Andy