none of those 3 is a good idea.
look at
http://www.learnasp.com/learn/dbopen.asp
for the best connection string for Access that minimizes chance for
unspecified error.
On Apr 3, 2005 9:43 PM, Driver, Nicholas <[EMAIL PROTECTED]> wrote:
> 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 the Yahoo! Terms of Service.
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/
