Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alxtech
Yak Posting Veteran
66 Posts |
 Posted - 2006-09-15 : 16:07:28
|
| I have the following connection string in my application:MM_objConn_STRING = "Provider=SQLOLEDB.1;Data Source=SQLDBPRD3;Database=Database_name;uid=user_id;Pwd=password;Network Library=DBMSSOCN;"and it works to an extend. It searches the records on the database but omits some of them, because the correct source has and instance. so i use:MM_objConn_STRING = "Provider=SQLOLEDB.1;Data Source=SQLDBPRD3\INST1;Database=Database_name;uid=user_id;Pwd=password;Network Library=DBMSSOCN;"but adding the instance brakes the connection to the database and no data is display.please help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-15 : 16:22:13
|
| This doesn't make any sense to me. If you are able to connect using the first connection string and then return any rows from the database, then you are getting there okay. So do you have a database on the default instance of this server that contains this data?You need to post the error of the second connection string in order for us to troubleshoot it.Tara Kizer |
 |
|
|
alxtech
Yak Posting Veteran
66 Posts |
Posted - 2006-09-18 : 09:28:28
|
| This is the error i get when using the mention second connection string with instance included:Microsoft OLE DB Provider for SQL Server error '80004005' [DBMSSOCN]General network error. Check your network documentation. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-18 : 09:49:35
|
| Is your instance SQLDBPRD3\Inst1 configured to use DBMSSOCN?Peter LarssonHelsingborg, Sweden |
|
|
|
alxtech
Yak Posting Veteran
66 Posts |
Posted - 2006-09-18 : 10:09:15
|
| yes all config are working correct, i check with database admin |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-18 : 10:14:58
|
If all configs are working correct, you should [per definition] be able to connect to the database.  Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
instance to database