asp-classicconnection-stringadoconnection

What's wrong with this ASP connection string?

I'm at the end of my rope on this. It should be so simple. I just need to know what's wrong with this connection string: 

dbc.open ("Driver={SQL Server}; Data Source = ServerName; Initial Catalog = InitialDB; " "User ID = Username; Password = Password;")

I get this error when running that line:

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I know ServerName is up and accepting connections, I know InitialDB exists, I know User ID and Password are valid for the database. What am I missing?

Solution

  • Try this...

    dbc.open ("Provider=SQLOLEDB; Driver={SQL Server}; Data Source = ServerName; Initial Catalog = InitialDB; User ID = Username; Password = Password; Network Library=dbmssocn;")