By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,659 Members | 1,957 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,659 IT Pros & Developers. It's quick & easy.

Package Solution

ddtpmyra
100+
P: 333
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.
Jan 7 '09 #1
Share this Question
Share on Google+
7 Replies


NeoPa
Expert Mod 15k+
P: 31,487
@ddtpmyra
I'm sorry. I couldn't understand that last paragraph. Could you possibly rephrase with whole sentences and punctuation.
Jan 7 '09 #2

ddtpmyra
100+
P: 333
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?
Jan 7 '09 #3

NeoPa
Expert Mod 15k+
P: 31,487
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?
Expand|Select|Wrap|Line Numbers
  1. Call MsgBox(CurrentDB.Tabledefs("YourTableNameHere").Connection
or
Expand|Select|Wrap|Line Numbers
  1. Debug.Print CurrentDB.Tabledefs("YourTableNameHere").Connection
Jan 7 '09 #4

ddtpmyra
100+
P: 333
Below is my actual set-up, could it be the port number I am connected too?


Expand|Select|Wrap|Line Numbers
  1.     Set objclient = New csdClient
  2.     Set objconnection = objclient.createconnection("c1Prod", "2881")
  3.     Set objsession = objconnection.createsession("login", "pass")
  4.  
  5.     Set objTransTable = objsession.createService("dbo.users")
  6.     Set objTransTable2 = objsession.createService("dbo.Ticket")
  7.  
Jan 8 '09 #5

NeoPa
Expert Mod 15k+
P: 31,487
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.
Jan 8 '09 #6

ddtpmyra
100+
P: 333
I tried both during event form like on load, on focus and on open event but nothing displayed
Jan 8 '09 #7

NeoPa
Expert Mod 15k+
P: 31,487
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).
Jan 8 '09 #8

Post your reply

Sign in to post your reply or Sign up for a free account.