Sandy,
Did you try to create DSN throgh the ODBC Administrator ?
When you create DSN for VFP free tbales, there is no databse either. You specify a directory where free tables are. Maybe it's the same with Advantage Database ?
>Hello all,
>We have a thrid party software in house that is using this Advantage
>Database that controls (it seems) record locking and doesn't allow changes to its fox2x tables while it is active. I have set up the ODBC driver, but when I go to create the connection, there is no database to coonect to just a bunch of ini files. I cannot even find a Dsn to create a connection.
>
>If anyone has had any experience with this, any help would be greatly appreciated. At their website, I received this guidance
>
>hconnect = SQLCONNECT('data')
>'data' is the DSN that was set up in the ODBC Administrator
>
>thanks for your help
>
--sb--