home bbs files messages ]

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