Package Solution

[ddtpmyra]

Hi,

Im using MS Access 2007 with table link with other vendor and create client installer using 'Package Solution'. Problem started when the vendor change its IP address I had ODBC connection error (ofcourse), so what I did was the following:

1. Update my ODBC connection under Administrative Tool set-up (same connection name)
2. Refresh the link table inside the MS Access using 'Link Table Manager' and direct it on the correct IP Address.

My question is... how come after this changes I made and created new installer I still got ODBC connection once I installed it to the user client. Where at first I didn't touch the users ODBC set-up? Is there any set-up I should do or missing? Please help.

[NeoPa]

@ddtpmyra
I'm sorry. I couldn't understand that last paragraph. Could you possibly rephrase with whole sentences and punctuation.

[ddtpmyra]

Hi Neopa.... what I mean to say is after the vendor change the IP address where my table was linked, now I need to set-up the ODBC setting local for each client, where originally on my first version which I never did. Is there missing setting I have to do after refreshing the table link using link manager inside the Access?

[NeoPa]

There are as many different sets of settings as there are ODBC drivers it seems.

Firstly, you need to consider whether it's ever a good idea to connect to any device via the IP address. This is what DNS is for. A fully qualified domain name should be used instead if possible.

Re-linking your table will only work if the settings used are still correct. If the IP address has changed and you're using that IP address as part of the connection info, then it will fail to pick up the new position of the server.

What is the Connection string of the linked table?

Call MsgBox(CurrentDB.Tabledefs("YourTableNameHere").Connection

or

Debug.Print CurrentDB.Tabledefs("YourTableNameHere").Connection

[ddtpmyra]

Below is my actual set-up, could it be the port number I am connected too?

    Set objclient = New csdClient
    Set objconnection = objclient.createconnection("c1Prod", "2881")
    Set objsession = objconnection.createsession("login", "pass")
 
    Set objTransTable = objsession.createService("dbo.users")
    Set objTransTable2 = objsession.createService("dbo.Ticket")
 

[NeoPa]

Could you possibly read my last post again and provide the information requested.

Please use the second option and copy / paste the results into here.

[ddtpmyra]

I tried both during event form like on load, on focus and on open event but nothing displayed

[NeoPa]

The second one displays in the Immediate Pane (See Debugging in VBA).

No code need actually be running in fact. Enter that code into the Immediate Pane itself (Ctrl-G) and hit <Enter>. It should respond with the data I need (assuming you've filled in the missing info).