Very Computer

by **Jame** » Mon, 18 Feb 2002 23:27:15

I get a Catastrophic Failure error message when I attempt
to connect to SQL Server via ASP/SQLOELDB. I have tried
several connection object parameters and none seem to
work. What can cause this? What must I consider? The code:

Conn = Server.CreateObject("ADODB.Connection")

with(Conn) {
ConnectionTimeout ="100"
ConnectionString = "Driver={SQL Server}; server=MSI;
DATABASE=MAC; UID=sa; PWD=;"
Open("MACSS")

Quote:}

Thank you,
James

by **Val Mazu** » Tue, 19 Feb 2002 22:32:11

Hi,

Do you have connection to database server? Probably you do
not have it. You can test it. Try to create DSN, which
will point to that database server, and test connection
during preparing DSN in ODBC data source from Control Panel

Val

Quote:>-----Original Message-----
>I get a Catastrophic Failure error message when I
attempt
>to connect to SQL Server via ASP/SQLOELDB. I have tried
>several connection object parameters and none seem to
>work. What can cause this? What must I consider? The code:

>Conn = Server.CreateObject("ADODB.Connection")

>with(Conn) {
> ConnectionTimeout ="100"
> ConnectionString = "Driver={SQL Server}; server=MSI;
>DATABASE=MAC; UID=sa; PWD=;"
> Open("MACSS")
>}

>Thank you,
>James
>.

by **Steven Bras [M** » Fri, 22 Feb 2002 08:54:49

Try using the OLEDB provider instead. Here's the connection string:

"provider=sqloledb;data source=MSI;initial catalog=MAC;User ID=sa;"

This may give us a more explicit error message.

Steven Bras, MCSD
Microsoft Developer Support/Visual Basic WebData

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.