Hi,
I am trying to open a database connection and having a problem--it will NOT
open.
Here is the code that I am using.
# security is the name of the database.
#user_data is the name of the access table
$path = $Server->MapPath("security.mdb");
$data = "driver={Microsoft Access Driver (*.mdb)};database=" . $path;
$Conn = $Server->CreateObject("ADODB.Connection");
# above goes fine
# then next line dies
$Conn->Open($data) || die "Cannot Open";
$RS = $Conn->Execute("SELECT * FROM user_data" );
If I leave out the "|| die statement",
when I try to access the Fields method with this code
foreach my $field (Win32::OLE::in($RS->Fields)) {
I get this
"Can't call method "Fields" on unblessed reference."
Now, I know the driver is good because the following vbscript code Works
!!!.
data_source = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("data/security.mdb")
Set con = Server.CreateObject("ADODB.Connection")
con.Open data_source
Anyone have any idea what I am doing wrong??
You help would be appreciated.
Thanks,
Thomas Whitney
Just for misc. informatinon
Ths following is from the MSDN ADO docs on the OPEN method
' Open a connection without using a Data Source Name (DSN)
Set Cnxn1 = New ADODB.Connection
Cnxn1.ConnectionString = "driver={SQL
Server};server=srv;uid=sa;pwd=pwd;database=Pubs"
Cnxn1.ConnectionTimeout = 30
Cnxn1.Open
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
