Hi H anonymous
I believe Peter is on the track here.
Your string should contain no quotes and must contain all connection
info as SERVERBASE, DATABASE etc.:
ConnectString = "DSN=contact;<other params>;uid=mylogid;pwd=mypass;"
The trailing semicolon may also be needed.
/gustav
> 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.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
