Hi Guys
I'm getting an"Unspecified error" on line 11 but this changes depending on
whic connection string I use (obviously).
The connection string is in an include file, and the code is:
<%
'=================================
Dim Con 'variable for connection to Access Database
Dim MyOriginal 'variable for the original database file
MyOriginal = "c:\inetpub\wwwroot\nickd\db\sqit.mdb"
Set Con = Server.CreateObject( "ADODB.Connection" )
Con.Open = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MyOriginal &
";" '<-- this is line 11
'Con.Open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & MyOriginal &
";"
'Con.Open = "Provider=MSDASQL; Driver={Microsoft Access Driver
(*.mdb)};Dbq=" & MyOriginal & ";"
'Con.Open = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & MyOriginal &
";"
'=================================
%>
As you can see, I've tried 4 different connection strings and none of them
work.
Any ideas?
cheers
Nick
--------------------------------------------------------------------------------
This E-Mail is intended only for the addressee. Its use is limited to that
intended by the author at the time and it is not to be distributed without the
author's consent. Unless otherwise stated, the State of Queensland accepts no
liability for the contents of this E-Mail except where subsequently confirmed in
writing. The opinions expressed in this E-Mail are those of the author and do
not necessarily represent the views of the State of Queensland. This E-Mail is
confidential and may be subject to a claim of legal privilege.
If you have received this E-Mail in error, please notify the author
and delete this message immediately.
--------------------------------------------------------------------------------
!DEPTSTAMP1!
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
