MSDE and Windows 98.

[bryja_klaudiusz[at]poczta[dot]fm]

Hi,

I try to connect to MSDE using software writing in C#. When I test this
software in Win XP it works properly but when I try on Win 98 it crash.

Situation:
1. Win XP, MSDE, connecting to local server and to server on Win 98
machine (works), this server hasn't instance name set (default),
2. Win 98, MSDE, connecting local show me error with connection
parameter (I got message "Invalid connection" when I use SqlConnection
component from C# or "..Instance name.." when I use OleDbConnection
component), this server has instance name e.g. MyName, when I connect to
this server from machine with win XP it works properly.

--
*Best regards,*
Klaudiusz Bryja

[John Bell]

Hi

Windows 98 has some restrictions see:
http://msdn.microsoft.com/library/de...r_sa2_1660.asp

To reference a default instance use "(local)" (without the quotes) or the
computer name:
http://msdn.microsoft.com/library/de...ar_cs_9okz.asp

You may want to connect with osql to make sure the connection can be made.

Posting your connection string may be useful!

John

"bryja_klaudiusz[at]poczta[dot]fm" <dl*@zmyly.pl> wrote in message
news:ca**********@atlantis.news.tpi.pl...

Hi,

I try to connect to MSDE using software writing in C#. When I test this
software in Win XP it works properly but when I try on Win 98 it crash.

Situation:
1. Win XP, MSDE, connecting to local server and to server on Win 98
machine (works), this server hasn't instance name set (default),
2. Win 98, MSDE, connecting local show me error with connection
parameter (I got message "Invalid connection" when I use SqlConnection
component from C# or "..Instance name.." when I use OleDbConnection
component), this server has instance name e.g. MyName, when I connect to
this server from machine with win XP it works properly.

--
*Best regards,*
Klaudiusz Bryja

[bryja_klaudiusz[at]poczta[dot]fm]

Hi,

Connection.ConnectionString =
"Server=(local);Database=DB_Name;Trusted_Connectio n=false;User
ID=sa;Pwd=1234;Persist Security Info=true";

Hi

Windows 98 has some restrictions see:
http://msdn.microsoft.com/library/de...r_sa2_1660.asp

To reference a default instance use "(local)" (without the quotes) or the
computer name:
http://msdn.microsoft.com/library/de...ar_cs_9okz.asp

You may want to connect with osql to make sure the connection can be made.

Posting your connection string may be useful!

John

"bryja_klaudiusz[at]poczta[dot]fm" <dl*@zmyly.pl> wrote in message
news:ca**********@atlantis.news.tpi.pl...

Hi,

I try to connect to MSDE using software writing in C#. When I test this
software in Win XP it works properly but when I try on Win 98 it crash.

Situation:
1. Win XP, MSDE, connecting to local server and to server on Win 98
machine (works), this server hasn't instance name set (default),
2. Win 98, MSDE, connecting local show me error with connection
parameter (I got message "Invalid connection" when I use SqlConnection
component from C# or "..Instance name.." when I use OleDbConnection
component), this server has instance name e.g. MyName, when I connect to
this server from machine with win XP it works properly.

--
*Best regards,*
Klaudiusz Bryja

--
*Pozdrawiam,*
Klaudiusz Bryja
ICQ#94940293

[Simon Hayes]

"bryja_klaudiusz[at]poczta[dot]fm" <dl*@zmyly.pl> wrote in message news:<ca**********@atlantis.news.tpi.pl>...

Hi,

I try to connect to MSDE using software writing in C#. When I test this
software in Win XP it works properly but when I try on Win 98 it crash.

Situation:
1. Win XP, MSDE, connecting to local server and to server on Win 98
machine (works), this server hasn't instance name set (default),
2. Win 98, MSDE, connecting local show me error with connection
parameter (I got message "Invalid connection" when I use SqlConnection
component from C# or "..Instance name.." when I use OleDbConnection
component), this server has instance name e.g. MyName, when I connect to
this server from machine with win XP it works properly.

This may be helpful:

http://support.microsoft.com/default...&Product=sql2k

As a basic test, you could try connecting locally with
isql.exe/osql.exe on the Windows 98 box; if that works successfully,
then you should probably look at your application connection
parameters. If it doesn't work, then please post the full command line
you tried, and also the exact error message you see. As far as I know,
Windows 98 only supports TCP/IP and multiprotocol connections, so you
might have to check that your code doesn't try to use named pipes in
some situations.

Simon