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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File DSN Issues??

Status
Not open for further replies.

Hurricane766

IS-IT--Management
Nov 30, 2004
34
CA
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:

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
 
Figured it out... be sure to check your paths very carefully... ;)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top