|
 |
asp_databases thread: Problems with OLEDB Connection string
Message #1 by "Brad Libby" <libby_brad@b...> on Wed, 13 Sep 2000 01:17:47 +0100
|
|
i have been using ODBC connections but now i am trying to set up an OLEDB
connection string and i am having some problems...
The server is - sqldata.abac.com
the database is - mydatabase
the user id - myuserid
the password - mypassword
this is the string i am using
conn.open "provider=sqloledb;persist security info = false;" & _
"data source = sqldata.abac.com;" & _
"database = mydatabase;" & _
"user id = myuserid;" & _
"password = mypassword"
And it is kicking back the following error
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Specified SQL server not found.
/register/thanks.asp, line 31
I am fairly new at this so your help would be greatly appreciated..
thanks..
Brad
Message #2 by Yoram Zehavi <YoramZ@i...> on Wed, 13 Sep 2000 10:52:41 +0200
|
|
add the following to your string: "name = yourdbname"
and if that will not be good, add "Initial Catalog = yourdbname" too
-----Original Message-----
From: Brad Libby [mailto:libby_brad@b...]
Sent: Wednesday, September 13, 2000 2:18 AM
To: ASP Databases
Subject: [asp_databases] Problems with OLEDB Connection string
i have been using ODBC connections but now i am trying to set up an OLEDB
connection string and i am having some problems...
The server is - sqldata.abac.com
the database is - mydatabase
the user id - myuserid
the password - mypassword
this is the string i am using
conn.open "provider=sqloledb;persist security info = false;" & _
"data source = sqldata.abac.com;" & _
"database = mydatabase;" & _
"user id = myuserid;" & _
"password = mypassword"
And it is kicking back the following error
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Specified SQL server not found.
/register/thanks.asp, line 31
I am fairly new at this so your help would be greatly appreciated..
thanks..
Brad
---
You are currently subscribed to asp_databases
Message #3 by =?iso-8859-1?Q?Gonzalo_Ruiz_de_Villa_Su=E1rez?= <gonzalo.ruizdevilla@a...> on Wed, 13 Sep 2000 10:53:38 +0200
|
|
I think you mispelled user Id (UserID) and password (pwd).
Regards,
Gonzalo
-----Mensaje original-----
De: Brad Libby [mailto:libby_brad@b...]
Enviado el: miércoles, 13 de septiembre de 2000 2:18
Para: ASP Databases
Asunto: [asp_databases] Problems with OLEDB Connection string
i have been using ODBC connections but now i am trying to set up an OLEDB
connection string and i am having some problems...
The server is - sqldata.abac.com
the database is - mydatabase
the user id - myuserid
the password - mypassword
this is the string i am using
conn.open "provider=sqloledb;persist security info = false;" & _
"data source = sqldata.abac.com;" & _
"database = mydatabase;" & _
"user id = myuserid;" & _
"password = mypassword"
And it is kicking back the following error
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Specified SQL server not found.
/register/thanks.asp, line 31
I am fairly new at this so your help would be greatly appreciated..
thanks..
Brad
|
|
|
View Cart
