ODBC Driver to Connect With IBM AS/400 System

Good Morning All:
I am trying to find an ODBC Driver that will connect my current
Microsoft Access Databas with our IBM AS/400 System. We have the
driver in Excel, but I don't believe it is the same driver for
Access. Any input would be greatly appreciated.
-Anthony Morano
Pension Fund Intern.
The ODBC driver for DB2 on AS/400 as provided by IBM; it is the same driver
for all client applications. Contact you IBM SE to purchase the client
connectivity software if you don't already have it. Otherwise try an SQL/400
newsgroup.
<antmorano@.gmail.com> wrote in message
news:1184852139.438805.176820@.e9g2000prf.googlegro ups.com...
> Good Morning All:
> I am trying to find an ODBC Driver that will connect my current
> Microsoft Access Databas with our IBM AS/400 System. We have the
> driver in Excel, but I don't believe it is the same driver for
> Access. Any input would be greatly appreciated.
> -Anthony Morano
> Pension Fund Intern.
>
sql

ODBC Driver to Connect With IBM AS/400 System

Good Morning All:
I am trying to find an ODBC Driver that will connect my current
Microsoft Access Databas with our IBM AS/400 System. We have the
driver in Excel, but I don't believe it is the same driver for
Access. Any input would be greatly appreciated.
-Anthony Morano
Pension Fund Intern.The ODBC driver for DB2 on AS/400 as provided by IBM; it is the same driver
for all client applications. Contact you IBM SE to purchase the client
connectivity software if you don't already have it. Otherwise try an SQL/400
newsgroup.
<antmorano@.gmail.com> wrote in message
news:1184852139.438805.176820@.e9g2000prf.googlegroups.com...
> Good Morning All:
> I am trying to find an ODBC Driver that will connect my current
> Microsoft Access Databas with our IBM AS/400 System. We have the
> driver in Excel, but I don't believe it is the same driver for
> Access. Any input would be greatly appreciated.
> -Anthony Morano
> Pension Fund Intern.
>

ODBC driver problem occurs on table create

Hi all!

I get the following error when trying to create a table:
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Connect()).

I use the same connection for table updates and selects and never have a problem. This only happens on table create. It also only happens on one machine (Win2K with SQL server 2000 Enterprise Edition). I've run this app without getting this problem on at least ten other machines (mostly WinXP, but also a few Win2K).

Any ideas?

nscdDoes the account that you're using have permissions on that SQL Server to create new tables?|||Yes it does.

I've also changed it so that I connect using the sa account, but still get the same problem.

Cheers

nscd|||Hi all

Further investigation has revealed that my client's machine was fairly out of date and installing the latest MDAC patch from MS resolved the problem.

Cheers

nscd

ODBC Driver for Access and AS/400

Good Morning All:
I am trying to find an ODBC driver for Microsoft Access that will
allow me to connect to our IBM AS/400 system. All inpout would be
appreciated.
-Anthony Morano
Pension Fund InternYou can use the Client Access driver you get with the client
for the AS/400.
You may want to post future questions to one of the Access
newsgroups. This group addresses ODBC and SQL Server.
-Sue
On Thu, 19 Jul 2007 14:06:15 -0000, antmorano@.gmail.com
wrote:

>Good Morning All:
>I am trying to find an ODBC driver for Microsoft Access that will
>allow me to connect to our IBM AS/400 system. All inpout would be
>appreciated.
>-Anthony Morano
>Pension Fund Intern

ODBC Driver for Access and AS/400

Good Morning All:
I am trying to find an ODBC driver for Microsoft Access that will
allow me to connect to our IBM AS/400 system. All inpout would be
appreciated.
-Anthony Morano
Pension Fund Intern
You can use the Client Access driver you get with the client
for the AS/400.
You may want to post future questions to one of the Access
newsgroups. This group addresses ODBC and SQL Server.
-Sue
On Thu, 19 Jul 2007 14:06:15 -0000, antmorano@.gmail.com
wrote:

>Good Morning All:
>I am trying to find an ODBC driver for Microsoft Access that will
>allow me to connect to our IBM AS/400 system. All inpout would be
>appreciated.
>-Anthony Morano
>Pension Fund Intern

ODBC Connection Problem

Hi all
I'm attempting to setup a linked server to a cache database within
Enterprise Manager. I setup an ODBC driver on the server and the
connection worked when tested.
Selected Micorsoft OLE DB Provider for ODBC Driver from the drop down
list.
Entered the data source name in the Data Source field and I keep
getting "error 7399: OLE DB provider 'MSDASQL' reported an error. OLE
DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize
returned 0x800004005;]"
Does the ODBC driver need to be installed on the same drive as SQL?
The driver is a system DNS stored on C: while SQL is installed on
another drive.
Or am I missing some parameters in the setup?
Thanks
mikeGot it to work.
Had to set everything up on the server and not on my machine.

Obtain "trusted connection" ?

Hi all!

I have a new computer, clean, I installed WinXP, and I want to connect a SQL Server (other computer in the same network)
For this I installed the client tools from SQL SERVER 2000 kit. Ok.
When I try to connect to the server, I can't connect through "trusted connection", only whit user name and password.
I mention that I set the sql server in mixed mode autentification.

When I try to connect from other computer (my laptop, or other computer from this network) I can connect both types of connection: trusted and with

sa (for example)

The question is:

How I can set up a "trusted connection" at SQL Server?

The computer is completely new, clean and has win xp with sp2.

Any opinion are considered.

Thanks in advance.

koci.You still need to add the login of the trusted connection to the server logins and grant it permission to use specific databases. SQL Server will not let you in purely on good looks and charm, even in the "trusted" mode.|||SQL Server will not let you in purely on good looks and charm, even in the "trusted" mode.

I have it on good authority that SQL Server will let you in if you know how to mix a good margarita. :D

Regards,

hmscott|||Thank's for the answers, I solved the problem.:)