Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File DSN not working

Status
Not open for further replies.

Hurricane766

IS-IT--Management
Nov 30, 2004
34
CA
Hi,

I can't get file DSNs to connect to my database. When I try to use the ODBC Administrator to create one, I enter the information and I get the error:
"A conncetion could not be made using the file data source parameters entered. Save non-verified file DSN"

What I'm I doing wrong?
I'm entering user id, password, start line and databasefile.

I also tried writing a file dsn from scratch and it won't work either.
Here's my asademo.dsn that I wrote by hand:
Code:
[ODBC]
databasefile=C:\Program Files\Sybase\SQL Anywhere 9\asademo.db
start=C:\Program Files\Sybase\ASA\dbsrv9.exe
DRIVER=Adaptive Server Anywhere 9.0
UID=dba
PWD=sql
 
Me again...

I also tried this for my start line and it still didn't work:

Code:
[ODBC]
enginename=asademo
databasename=asademo
databasefile=C:\Program Files\Sybase\SQL Anywhere 9\asademo.db
start=C:\Program Files\Sybase\ASA\dbeng9.exe -c 16M
DRIVER=Adaptive Server Anywhere 9.0
UID=dba
PWD=sql

Thanks
 
Figured it out... be sure to check your paths very carefully... ;)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top