Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 17,922 of 19,505    |
|    Bob Barrows to Erland Sommarskog    |
|    Re: ODBC & Access-DB on Windows 2003 Ser    |
|    01 Oct 10 02:23:55    |
   
   From: reb01501@NOSPAMyahoo.com   
      
   Erland Sommarskog wrote:   
   > Gerd Brix (gbrix@gmx.de) writes:   
   >> I'm not sure whether this is the right group to ask ... please advise   
   >> which on if not.   
   >>   
   >> I have a small Perl application that uses Win32::ODBC to access a MDB   
   >> file. Now, this needs to run on a Windows 2003 Server (64 bit) but I   
   >> don't have any idea how I can create the required ODBC data source   
   >> there.   
   >>   
   >> Which driver (or other software) would I need to do this?   
   >   
   > I have not looked at Win32::ODBC for a long time, but I would assume   
   > that all you need is to change the connection string to read:   
   >   
   > Driver={Sql Native   
   > Client};Server=servername;Database=yourdb;Integrated Security=SSPI   
   >   
   That would be great if he was using SQL Server: he says he's accessing a   
   "MDB" file which is Jet (Access). So his question is not really relevant   
   here. Frankly I don't know of a group devoted to answering ODBC questions,   
   so:   
      
   This article describes using Jet in a 64-bit environment:   
   http://support.microsoft.com/kb/957570   
      
   I found it by searching for "64-bit jet driver"   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca