deploy DBX with MSSQL D2007

[Dwight Crevelt]

D2007, MSSQL, tdataset component,

I have a simple application that runs well on the development machine, but I
get
SQL state error 08001: sql error code 6 specified server does not exist.

I have added ALL the DBX*.dll's and DBX*.ini's, midas.dll
dbxcommondriver100.bpl, dbxdynalinkdriver100.bpl, rtl100.bpl,dbrtl100.bpl
to the execution directory

and still no luck

How do you deploy this? XP and W2000
I can ping the server so I know the connection is there.

[Dwight Crevelt]

This appears to be a win2000 issue
I was able to get it to work on XP pro

any Ideas?
Thanks
"Dwight Crevelt" <***@creveltcomputer.com> wrote in message news:47ae8a1c$***@newsgroups.borland.com...
D2007, MSSQL, tdataset component,

I have a simple application that runs well on the development machine, but I
get
SQL state error 08001: sql error code 6 specified server does not exist.

I have added ALL the DBX*.dll's and DBX*.ini's, midas.dll
dbxcommondriver100.bpl, dbxdynalinkdriver100.bpl, rtl100.bpl,dbrtl100.bpl
to the execution directory

and still no luck

How do you deploy this? XP and W2000
I can ping the server so I know the connection is there.

[Jan Doggen]

Hi Dwight

You can ping the server but that does not mean you can access the database.
What flavour of SQL server is it? E.g. if you install SQL Express it will by
default not install for remote access from another machine.
Does the developer machine connect to the same DB or to a development DB?
Then there's methods of connection: named pipes, tcpip etc. Maybe something
is off there...
If it says 'specified server not exists' it's probably not a login issue
(like you using SQL logins and the server being set up for Windows logins
only).
Are your TSQLConnection parameters properly set on that other machine.
Is MDAC up to date?

Happy hunting
Jan

Post by Dwight Crevelt
D2007, MSSQL, tdataset component,
I have a simple application that runs well on the development machine, but I
get
SQL state error 08001: sql error code 6 specified server does not exist.
I have added ALL the DBX*.dll's and DBX*.ini's, midas.dll
dbxcommondriver100.bpl, dbxdynalinkdriver100.bpl, rtl100.bpl,dbrtl100.bpl
to the execution directory
and still no luck
How do you deploy this? XP and W2000
I can ping the server so I know the connection is there.
--
Dwight

[Dwight Crevelt]

We are talking about a XP Delphi development machine accessing a remote MS
2005 SQL server - works fine
I got it to run on an XP client by adding the dll's and the ini's - works
fine
Win 2000 client produces the error - probably outdated sqldriver in odbc, it
is a nuisance now and not worth pursuing as we will not deploy win 2000
clients.

Thanks

"Jan Doggen" <***@planet.nl> wrote in message news:***@newsgroups.borland.com...
Hi Dwight

You can ping the server but that does not mean you can access the database.
What flavour of SQL server is it? E.g. if you install SQL Express it will by
default not install for remote access from another machine.
Does the developer machine connect to the same DB or to a development DB?
Then there's methods of connection: named pipes, tcpip etc. Maybe something
is off there...
If it says 'specified server not exists' it's probably not a login issue
(like you using SQL logins and the server being set up for Windows logins
only).
Are your TSQLConnection parameters properly set on that other machine.
Is MDAC up to date?

Happy hunting
Jan

Post by Dwight Crevelt
D2007, MSSQL, tdataset component,
I have a simple application that runs well on the development machine, but I
get
SQL state error 08001: sql error code 6 specified server does not exist.
I have added ALL the DBX*.dll's and DBX*.ini's, midas.dll
dbxcommondriver100.bpl, dbxdynalinkdriver100.bpl, rtl100.bpl,dbrtl100.bpl
to the execution directory
and still no luck
How do you deploy this? XP and W2000
I can ping the server so I know the connection is there.
--
Dwight