Problems using a file-dsn under windows xp

Problems using a file-dsn under windows xp

am 16.10.2005 12:15:09 von taco cohen

Hello,

I'm trying to create a DSN file with the ODBC Data Source Administrator, but
I'm running into some problems. I have succesfully created a user-DSN, but
when I try to create a file-DSN, I first have to enter the driver, then
enter the name, and then it creates the file. I'm not prompted to enter
other parameters like database, user, password.. So it creates a DSN file
with these contents:
[ODBC]
DRIVER=MySQL ODBC 3.51 Driver

So I entered the other parameters manually, but I'm afraid I made an error.
Here is what it looks like now:
[ODBC]
DRIVER=MySQL ODBC 3.51 Driver
UID=root
STMT=
OPTION=3
PORT=
PASSWORD=
SERVER=localhost
DATABASE=gamedata
DESC=MySQL-gamedata

When I try to use this file-dsn, I get the error "Invalid window handle for
connection completion argument."

What am I doing wrong?
Btw, I also tried USER instead of UID.

Thanks in advance,

Taco Cohen



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Problems using a file-dsn under windows xp

am 17.10.2005 01:52:28 von Daniel Kasak

taco cohen wrote:

> Hello,
>
> I'm trying to create a DSN file with the ODBC Data Source
> Administrator, but I'm running into some problems. I have succesfully
> created a user-DSN, but when I try to create a file-DSN, I first have
> to enter the driver, then enter the name, and then it creates the
> file. I'm not prompted to enter other parameters like database, user,
> password.

File & User DSNs have never worked for me. I use 'System' DSNs, which
seem to work fine.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org