Hi Yuri,
Thank you very much for your reply.
> Instead of ([Access FinData]) you need a valid datasource name as it is in > the ODBC ini file.
'Access FinData' IS a valid datasource that I've created. It uses the Access driver but leaves the Database empty. There are no UserID or PW.
I tried your code. It prompts me 3 times.
My problem is not in a bad connection name; it is in subsequent calls re-prompting for a database even though the database has been specified for the connection:
==================================
xxx = [C:\Temp\Lookup1.mdb]
Create Connection FinConnect ;
DataSource [Access FinData] ;
Database (xxx)
? DBGetProp([FinConnect],"CONNECTION","Database") && returns [C:\Temp\Lookup1.mdb]
* Create a connection handle for the SqlTables command
lnConnect = SqlConnect([FinConnect]) && this reprompts me for a database; why ?
===================================
Remember, I NEVER get the datasource/connection prompt. I keep getting prompted for an mdb. It is the only prompt that I'm trying to get rid of.
Again, thanks for your help. I hope we can see this through.
Henry
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only