Hi,

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?

Thanks for reading,
Gerd

Gerd Brix (gbrix (AT) gmx (DOT) de) writes:
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;Integrat ed Security=SSPI

The last indicades Windows authentication, If you use SQL authentication,
you should instead specify UserID and PWD.

Disclaimer: ODBC, OLE DB and .Net has overlapping keywords for the
connection strings, but there are some variations, and I am doing all this
from memory. You can also look at www.connectionstrings.com.

As for drivers, there are several versions. Driver={SQL Server} is the
safe option. This driver comes with the operating system, so it is
always there. But it only supports features in SQL 2000. SQL Native Client
is the driver that shipped with SQL 2005. The driver that shipped
with SQL 2008 is "SQL Native Client 10", I think, but I'm not sure.
Depending on the machine, these drivers may or may not be installed.

A more far-reaching option is to rip out Win32::ODBC entirely, and
switch to Win32::SqlServer, but as the name indicates this module
supports SQL Server only. It's a completely different API that sits
on top of OLE DB. That is probably av overkill, though. What you
should be aware of though, is that there are substantial differences
between the SQL dialects in Access and SQL Server. Queries that adhere
to the standard core in SQL will work, but there is a fair chance that
you beyond that.

You find Win32::SqlServer on on my web site,
http://www.sommarskog.se/mssqlperl/index.html


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) seLinks for SQL Server Books Online:SQL 2008: http://msdn.microsoft.com/en-us/sqls...514207.aspxSQL 2005: http://msdn.microsoft.com/en-us/sqls...895970.aspxSQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

You have 32-bit and 64-bit ODBC on this server.

You can only access the 64-bit one in your menu. But in my opinion MS
Access uses only 32-bit ...

I don't know the path for the two versions, but look für odbcad*.exe.
At Vista:
Data Sources (ODBC) 32bit: %SystemRoot%\SysWOW64\odbcad32.exe
Data Sources (ODBC) 64bit: %SystemRoot%\system32\odbcad32.exe

Lutz

In deutsch:

Gerd ... es gibt zwei ODBC-Versionen. Standardmäßig erreichst du über
das Menü nur die 64bit-Variante. Die 32bit-Variante, welche auch die
Access-ODBC-Treiber enthält erreichst du nur durch direktes Aufrufen der
32bit-EXE. Pfad siehe oben.

Access-Probleme kannst du auch unter
de.comp.datenbanken.ms-access loswerden

Erland Sommarskog wrote:
"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"

On 1 Okt., 08:16, Lutz Uhlmann <n... (AT) invalid (DOT) invalid> wrote:
Yeah! That did it! Many thanks!

Ich war mir nicht sicher -- schließlich wurde nur MS-SQL angeboten ;-)

Cheers,
Peter

Bob Barrows (reb01501 (AT) NOSPAMyahoo (DOT) com) writes:
I saw that part, but I assumed that Gerd was now moving to SQL Server -
why else would she post here :-) But I see how there is no mention at
all of SQL Server. I guess I got carried away when I saw Perl being
mentioned. :-)



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx