Hello,
for linking tables in Access through VBA, I'm doing the following with a
login form:
1. I open a database connection:
"Set dbsodbc = DBEngine.OpenDatabase("Test", dbDriverNoPrompt, False,
GetODBCString)"
where GetODBCString =
"ODBC;DSN=Test;SERVERNODE=xxx.x.x.x;DATABASE=Test;UID=Username;PWD=Password"
2. I make a loop through all Tabledefs and link each table I need into
access.
With this code I don't get a ODBC connection prompting, after I made a
login.
Hope that helps
Peter
-----Urspr�ngliche Nachricht-----
Von: H [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 3. Mai 2004 16:25
An: [EMAIL PROTECTED]
Betreff: Re: How do I write my connection string to avoid ODBC
connection prompting
re: ConnectString='DSN=contact';uid='mylogid';pwd='mypass'
I am sorry but I can't relate your Linux Alias solution to my windows
environment..
Surely there is a parameter like "no_prompt" or something similar I can use
in my DSN... I get this prompt when using Access and ODBC-linking a table.
Any other help much appreciated.
Jean-Michel OLTRA <[EMAIL PROTECTED]> wrote:
Le vendredi 30 avril 2004, H a �crit...
bonjour,
> This is my connection string ....
> ConnectString='DSN=contact';uid='mylogid';pwd='mypass'
> What do I need to add to it to avoid getting the ODBC prompt (the same
dialog one uses to define the DSN in the first place).
Linux box ? I define an alias:
alias odbcdatabase='uniread /usr/local/iodbc/bin/odbctest ConnectString'
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
---------------------------------
Post your free ad now! Yahoo! Canada Personals
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
