Hi

It's telling you that it cannot find the DSN, so the first question that comes to mind is - When you changed machines, did you set up the DSN on the W98 machine? You can check by going to the Start/Settings/Control Panel and ODBC Data Sources. I'm betting that there is no DSN by the name 'mydsn'.



>Hello,
>Im trying to access a SQL Server 2000 from FP2.6 via fpsql.dll
>
>It works ok on a Win XP machine, but fails on W98.
>
>The dbconnect() call returns with code -2
>
>The error message is
>ODBC error IM002 [microsoft][odbc dll] Data source name not found and no default driver specified.
>
>The syntax I use is
>
>store dbconnect(mydsn,myuser,mypwd) to nConn.
>Also tried
>store dbconnect(mydsn,myuser,mypwd,mydatabase) to nConn
>
>It returns -2 in nConn on W98 SE, MDAC 2.6 SP1.
>mydsn exists and works ok
>
>Any ideas?
>
>TIA