Hello,
I am trying to update a table in an Access 2007 database on a pc. I have created a system DSN without a password but cannot get it to connect. It says I require a password but the database has no user or password nor can I create one apparently
Additionally, I can't find an odbc.ini anywhere to see what is being passed.
Any suggestions gratefully received.
ODBC connection to Access 2007
Moderators: chulett, rschirm, roy
ODBC connection to Access 2007
Colin Larcombe
-------------------
Certified IBM Infosphere Datastage Developer
-------------------
Certified IBM Infosphere Datastage Developer
Re: ODBC connection to Access 2007
Is this Access file and ODBC DSN on the same server as DataStage?clarcombe wrote:Hello,
I am trying to update a table in an Access 2007 database on a pc. I have created a system DSN without a password but cannot get it to connect.
Can you use something like Excel or Microsoft Query to first prove that the ODBC Source is working before you try and use it with DataStage? Again, you'd need to do all this on the DataStage server.
If the Access file is on another computer, then the ODBC source (on the server) would need to reference the file using a UNC path (maybe this is where your username / password issue is coming from), or you should copy the MDB file to the server.
Re: ODBC connection to Access 2007
Yes the Access database is on the same server and I can access it as a ODBC DSN using Excel
Colin Larcombe
-------------------
Certified IBM Infosphere Datastage Developer
-------------------
Certified IBM Infosphere Datastage Developer