MSDE newbie question: connection strings

I installed MSDE on a Windows XP SP1 PC on our network. We don't have a
domain controller.
If I access this database via ADO, how do I construct the connection
string? As I understand it, this is of the form:
Provider=SQLOLEDB; Data Source=server_name; Initial
Catalog=database_name; User ID=username; Password=password;
Is the server name just the name or IP address of the PC running MSDE?
Are there any other subtleties I should be aware of?
Simon Elliott http://www.ctsn.co.uk
hi Simon,
"Simon Elliott" <Simon at ctsn.co.uk> ha scritto nel messaggio
news:OuUGwZwQEHA.3580@.TK2MSFTNGP11.phx.gbl...
> I installed MSDE on a Windows XP SP1 PC on our network. We don't have a
> domain controller.
> If I access this database via ADO, how do I construct the connection
> string? As I understand it, this is of the form:
> Provider=SQLOLEDB; Data Source=server_name; Initial
> Catalog=database_name; User ID=username; Password=password;
> Is the server name just the name or IP address of the PC running MSDE?
> Are there any other subtleties I should be aware of?
if the MSDE instance has been installed as the default intance, it's name
will just be the ComputerName and/or it's IP address... if it has been
installed as a named instance, it's name will be
ComputerName\InstanceName...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Issue

Hi,
I have a strange issue. We have a DataTable in MSDE with
800 columns. The column name strings are very long.. about
200 characters or more.
When we try to do BULK INSERT into this table, MSDE
results in a General Network error.
We use SQLDataAdapter.
I am working against a very extreme scenario.
Any help?
Regards
Sundari.
It is impossible to have column in a table with its name being longer than
128 characters. SQL Server/MSDE does not allow column name longer than 128
characters.
"Sundari" <sundari_t@.hotmail.com> wrote in message
news:12d101c4ba7f$b1198870$a301280a@.phx.gbl...
> Hi,
> I have a strange issue. We have a DataTable in MSDE with
> 800 columns. The column name strings are very long.. about
> 200 characters or more.
> When we try to do BULK INSERT into this table, MSDE
> results in a General Network error.
> We use SQLDataAdapter.
> I am working against a very extreme scenario.
> Any help?
> Regards
> Sundari.