Connection String,Hard code works, but reading ini file doesn't

[cyberbiker]

When I hardcode the connection string, everything appears fine. But when I try to read the connection string from an ini file, the ODBC connection fails.

The following code works:

Defaulttype = dbUseODBC
Set dbconnection = OpenConnection("", dbDriverNoPrompt, False, "ODBC;dsn=LocalServer;database=testa;uid=tah;pwd=;""&quot

when I attempt to use this code:
Defaulttype = dbUseODBC
set dbconnection = OpenConnection(bfGetODBCConnect())
The connection fails.

bfGetODBCConnect() returns the connection string from an ini file.

When I set a watch, bfGetODBCConnect returns what appears to be an identical string (including spaces):

"", dbDriverNoPrompt, False,
"ODBC;dsn=LocalServer;database=testa;uid=tah;pwd=;"""

Anybody have any ideas what I am doing wrong? Terry (cyberbiker)

 

[sleipnir214]

Are you sending a single string into a function that requires 4 input parameters?

I'm afraid it doesn't work that way. Perfection in engineering does not happen when there is nothing more to add. Rather it happens when there is nothing more to take away.

 

[cyberbiker]

Oh Do I feel stupid!!!! Of course that is it.
Sorry to be so goofy. Thanks for the help Terry (cyberbiker)

 

[cwarner]

Hi,

would I use this function:

bfGetODBCConnect()

if I want to replicate my Access/SQL-server app STRUCTURE, not data, in other locations? I need to connect to the person's server w/o hard-coding the connection string.

thanks!
christy.