Re: ado and connection string
From: Tom Alter (Lord2702_at_MSN.com)
Date: 03/23/05
- Next message: Joseph Geretz: "BLOB Column in a Disconnected Recordset"
- Previous message: Giupin: "ado and connection string"
- In reply to: Giupin: "ado and connection string"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 22 Mar 2005 17:42:19 -0800
Use one of these: %s is your Access Database file name
// OLE DB Driver string for MS Access database
"Data Source=\"%s\";Provider=\"Microsoft.Jet.OLEDB.4.0\";"
"Jet OLEDB:Engine Type=5;"
// ODBC
// Microsoft Access Driver. Version: 9.0
// e.g.
// SELECT * FROM <SquareBracket>table name<SquareBracket>
// Table name should be inside the squarebrackets, spaces
// dash allowed.
"Driver={{Microsoft Access Driver (*.mdb)}}; "
"MaxBufferSize=2048; DriverId=25; DBQ=%s; "
"Giupin" <peppepin@libero.it> wrote in message
news:hP20e.687537$b5.31159318@news3.tin.it...
> I've created a web page in ASP using vbscript with ado objects,
> I'm testing it in a pc with Xp Pro and IIS 5.1,
> I've not setted a Data Source Name in "ODBC data administrator"
> The DB is an MsAccess file.
>
> When i try to open the db appear this message:
> "[Microsoft OLE DB Provider for ODBC Drivers]"
> "[Microsoft] [Driver Manager ODBC]"
> "data origin name not found and predefined driver non specified."
>
>
> this is the connection string:
> "Provider=MSADSQL; DRIVER=Microsoft Access Driver (*.mdb);" &_
> "SERVER=localhost; DATABASE=C:\mydb.mdb;"
>
> it is correct? thanks.
>
>
- Next message: Joseph Geretz: "BLOB Column in a Disconnected Recordset"
- Previous message: Giupin: "ado and connection string"
- In reply to: Giupin: "ado and connection string"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
