escaping semi colon in connectionstring

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,
I created a database having ; in name e.g. abc;def
Now, while connecting to this database using ADO I am getting "Invalid
connection string attribute" error. How can I escape semicolon in connection
string.

Connection string:
Provider=SQLOLEDB;Server=S1;Database=abc;def;Trusted_Connection=NO;User
Id=a;Password=a;

TIA,
Ajey


.

Relevant Pages

  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... Depending on the database you are using, ... you need to know the basics of the connection string and can populate ... no. the login box which you are talking about was provided to ODBC ... When the user exits the dialog box, the driver connects ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Change Connection String at runtime.
    ... easily moved to another database, or have versions for each database. ... connection string to the connectionobject before the connection opens. ... *The Server IP number is different for every deployment. ... It appears that the generated code uses the application settings to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... Depending on the database you are using, ... database without knowing anything beforehand except the driver name. ... you need to know the basics of the connection string and can populate ... no. the login box which you are talking about was provided to ODBC ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Change Connection String at runtime.
    ... exposes custom objects that are implemented to use the custom data access ... easily moved to another database, or have versions for each database. ... and protocols each data source exposes. ... connection string to the connectionobject before the connection opens. ...
    (microsoft.public.dotnet.framework.adonet)