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 |
|
drman
Starting Member
38 Posts |
 Posted - 2003-03-11 : 15:48:07
|
| I have recently developed an application in VB 6.0. Originally, I was connecting to the SQL2000 server utiliting ODBC. I was attempting to do various extremely large queries and having problems. MS recommended using OLE DB Provider for SQL Server. On my development PC, everything is great, but when installing it on a new workstation, I receive the message:[DBNMPNTW]Secified SQL server not found. SQLConnectString = "Provider = sqloledb;" & _ "Data Source = SQLSERVER;" & _ "Initial Catalog = mydb;" & _ "User ID = userid;" & _ "Password = userpassword; '"I build the connection string from the above code. Again, it works fine in my development environment. Do I have to do something different to the workstations as with odbc connections. I setup an odbc connection under admin tools to make sure I could connect outside of the app. I am sure the answer will be very obvious, but I sure can't figure it out.DRMAn |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-03-11 : 15:50:58
|
| Add this:SQLConnectString = "Provider=sqloledb;" & _ "Data Source=SQLSERVER;" & _ "Initial Catalog=mydb;" & _ "User ID=userid;" & _ "Password=userpassword; " & _ "Network=dbmssocn; "I'm not sure if the spaces matter or not, but it's probably better not to include spaces in the connection string unless the setting(s) themselves have spaces. |
 |
|
|
drman
Starting Member
38 Posts |
Posted - 2003-03-12 : 13:12:54
|
| Thanks, but I am still unsuccessful.I added the Network= Line to my code and it still is giving me the same error message. My development environment has SQL MSDE loaded and I can get right into the app. When I use the app on the new workstation, it does not work.. is there something that I may be missing from either the deployment of the vb app or is there something that I am missing from the Win2000 install. the actual SQL server I am trying to connect to is connected to the dmz port on my router..DRMAN |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-12 : 13:32:48
|
| Do you get the exact same error: [DBNMPNTW]Secified SQL server not found? You should be getting a different message since you are pointing to a different DLL now. The message should indicated DBMSSOCN now. Which port are you using on your router? Have you configured SQL Server to listen on that port?TaraEdited by - tduggan on 03/12/2003 13:34:14 |
|
|
|
|
|
|
OLEDB Provider for SQL - not able to find server