Problem with Network

FAQ

Profile

Problem with Network

Database Help (Home) -> Visual Basic -> ODBC

Next: Reading Excel from Visual Basic 6.0

Author

Message

Gary Wardell

External

Since: Apr 15, 2005
Posts: 1

(Msg. 1) Posted: Mon Sep 12, 2005 11:34 am Post subject: Problem with Network Archived from groups: microsoft>public>vb>database>odbc (more info?)

I seem to have run into a problem where when setting the connection for a linked table in a Jet database and doing a RefreshLink the network library gets changed from DBMSSOCN to DBMSLPCN. It seems to only do this on certain machines. The connect string is: ODBC;DRIVER=SQL Server;SERVER=ComServer;UID=xxxx;PWD=xxxx;APP=LoanApp;WSID=COM2;DATABASE=Loa nProce15;NETWORK=DBMSSOCN;AutoTranslate=No;QuoteID=No;AnsiNPW=No Is there anyway for me to prevent this behaviour? We are using the DAO 3.51 library. Gary >> Stay informed about: Problem with Network

Display posts from previous:

Related Topics:

RDO resultset performance problem - Hi to all, I have a big performance problem with looping threw rdoresultset. I made some very complex sql queries. They link like 5 tables and uses a couple subqueries. The number of returned rows is something like 1000. Query execution takes about 1..

HOWTO: Clone SQL db ? - Hi all, I'm having a SQL Server database called X. For testing and training, I would like to make a copy of the entire DB to Y. This copy should include all data, properties, indexes, views, etc. Unfortunately, all my attempts to automate this..

Change connect string for Excel Queries using an ODBC Driver - Reference: ODBC Connection for MAS90 MAS200 In Excel we have an ODBC Connection String with a physical (hard coded) path to the data. We have changed the servers. We do not want to recreate all of the queries. How can we edit the ODBC path inside of..

ISA 2006 with My sql Connection - Hi, Please help me,acutually I am facing problem with ISA 2006.It does not connect Mysql data base. It is giving error"Can't connect to Mysql server on "IP" 10060."

Compile Error - Can anyone please help me to solve this problem I have when I tried to compile and run my program written in VB 6.0? Problem: I used variable declaration such as db as Database and ws as Workspace. I use ODBC way to connect my VB form interface with....

	Database Help (Home) -> Visual Basic -> ODBC	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum