Hurricane766
IS-IT--Management
Hi,
I'm using Sybase ASA 9 and 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"
Also, when I configure a .dsn file that I wrote myself and then click ok, I get the error: "General error: Invalidfile dsn 'C:\asademo.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:
I've also tried the start line as: start=C:\Program Files\Sybase\ASA\dbsrv9.exe
Thanks for any help
I'm using Sybase ASA 9 and 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"
Also, when I configure a .dsn file that I wrote myself and then click ok, I get the error: "General error: Invalidfile dsn 'C:\asademo.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\dbeng9.exe
DRIVER=Adaptive Server Anywhere 9.0
UID=dba
PWD=sql
I've also tried the start line as: start=C:\Program Files\Sybase\ASA\dbsrv9.exe
Thanks for any help