1. HELP! ODBC Connection String
This is a multi-part message in MIME format.
------=_NextPart_000_0016_01C4D4BD.1278CA70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
I've downloaded Matt Lewis's ODBC wrapper and im really confused with the
connection string business.
I've got database.dsn that connects to database.mdb, an MS Access database, so
how do I use it?
It would be great if anyone had a example program or if they could explain how
to use a filedsn.
chers
Alx
------=_NextPart_000_0016_01C4D4BD.1278CA70
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I've downloaded Matt Lewis's ODBC wrapper and im
really confused with the connection string business.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I've got database.dsn that connects to
database.mdb, an MS Access database, so how do I use it?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It would be great if anyone had a example program
or if they could explain how to use a filedsn.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>chers</FONT></DIV>
<DIV><FONT face=Arial size=2>Alx</FONT></DIV></BODY></HTML>
------=_NextPart_000_0016_01C4D4BD.1278CA70--
2. Re: HELP! ODBC Connection String
Alex Chamberlain wrote:
>
> I've downloaded Matt Lewis's ODBC wrapper and im really confused with the
> connection
> string business.
>
> I've got database.dsn that connects to database.mdb, an MS Access database, so
> how
> do I use it?
>
> It would be great if anyone had a example program or if they could explain how
> to use
> a filedsn.
>
I've never used a filedsn, but I'd recommend trying something like:
conn = openDriverConnectionODBC( "FILEDSN=database.dsn", hwnd, SQL_DRIVER_PROMPT
)
Matt Lewis
3. Re: HELP! ODBC Connection String
I worked it out thanks you must use the full path for some reason! I used
current_dir()
----- Original Message -----
From: "Matt Lewis" <guest at RapidEuphoria.com>
To: <EUforum at topica.com>
Sent: Sunday, November 28, 2004 10:48 AM
Subject: Re: HELP! ODBC Connection String
>
>
> posted by: Matt Lewis <matthewwalkerlewis at yahoo.com>
>
> Alex Chamberlain wrote:
> >
> > I've downloaded Matt Lewis's ODBC wrapper and im really confused with
the connection
> > string business.
> >
> > I've got database.dsn that connects to database.mdb, an MS Access
database, so how
> > do I use it?
> >
> > It would be great if anyone had a example program or if they could
explain how to use
> > a filedsn.
> >
>
> I've never used a filedsn, but I'd recommend trying something like:
> }}}
<eucode>
> conn = openDriverConnectionODBC( "FILEDSN=database.dsn", hwnd,
SQL_DRIVER_PROMPT )
> </eucode>
{{{
>
> Matt Lewis
>
>
>
>
