By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 1,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

Connection String suddenly Stops working

P: n/a
Hi

Odd one here, I have a local version of SQL running on my laptop for
demos, been working fine for years yet yesterday I suddenly get an
error "Invalid Conection Parameter" running a sproc using the
following connection string (Its an Access 2002 App to SQL 2000)

strConnect = "Network=DBMSSOCN;Server=" & DB_Server & ";DRIVER=SQL
Server;UID=abc;PWD=def"

Works fine if I use the server based SQL resource

So I change it to be the following and it starts working ????

strConnect = "Server=" & DB_Server & ";DRIVER=SQL
Server;UID=abc;PWD=def"

So it started not liking the 'Network=DBMSSOCN' part but both the
datbases have TCP/IP and Named Pipes setup as network protocols and
bot have not chnaged config for years

I did install SP2 for XP a few weeks ago but I'm sure I have run it
since (mind you I wish I'd never done SP2 with all the unasked for
'extras' MS dump on your PC but thats another thread)

Thanks all
shaun
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Strange. It looks that both strings are correct (although I would put the
network part toward the end as a personal preference).

I often refer to http://www.connectionstrings.com/ for examples and usage of
connection strings.

--
Keith
"Shaun" <sh********@msn.com> wrote in message
news:4a**************************@posting.google.c om...
Hi

Odd one here, I have a local version of SQL running on my laptop for
demos, been working fine for years yet yesterday I suddenly get an
error "Invalid Conection Parameter" running a sproc using the
following connection string (Its an Access 2002 App to SQL 2000)

strConnect = "Network=DBMSSOCN;Server=" & DB_Server & ";DRIVER=SQL
Server;UID=abc;PWD=def"

Works fine if I use the server based SQL resource

So I change it to be the following and it starts working ????

strConnect = "Server=" & DB_Server & ";DRIVER=SQL
Server;UID=abc;PWD=def"

So it started not liking the 'Network=DBMSSOCN' part but both the
datbases have TCP/IP and Named Pipes setup as network protocols and
bot have not chnaged config for years

I did install SP2 for XP a few weeks ago but I'm sure I have run it
since (mind you I wish I'd never done SP2 with all the unasked for
'extras' MS dump on your PC but thats another thread)

Thanks all
shaun


Nov 13 '05 #2

P: n/a
Thanks for the link Keith

Yep it is odd as I thought both were fine as well and the one now is
not working worked fine for months!!!

Ah well the odditiess of Microsoft

Cheers
Shaun

"Keith Kratochvil" <sq***********@comcast.net> wrote in message news:<uQ**************@TK2MSFTNGP12.phx.gbl>...
Strange. It looks that both strings are correct (although I would put the
network part toward the end as a personal preference).

I often refer to http://www.connectionstrings.com/ for examples and usage of
connection strings.

--
Keith
"Shaun" <sh********@msn.com> wrote in message
news:4a**************************@posting.google.c om...
Hi

Odd one here, I have a local version of SQL running on my laptop for
demos, been working fine for years yet yesterday I suddenly get an
error "Invalid Conection Parameter" running a sproc using the
following connection string (Its an Access 2002 App to SQL 2000)

strConnect = "Network=DBMSSOCN;Server=" & DB_Server & ";DRIVER=SQL
Server;UID=abc;PWD=def"

Works fine if I use the server based SQL resource

So I change it to be the following and it starts working ????

strConnect = "Server=" & DB_Server & ";DRIVER=SQL
Server;UID=abc;PWD=def"

So it started not liking the 'Network=DBMSSOCN' part but both the
datbases have TCP/IP and Named Pipes setup as network protocols and
bot have not chnaged config for years

I did install SP2 for XP a few weeks ago but I'm sure I have run it
since (mind you I wish I'd never done SP2 with all the unasked for
'extras' MS dump on your PC but thats another thread)

Thanks all
shaun

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.