SEARCH
Knowledgebase: MySQL
"Invalid Instance.Invalid Connection" error Connecting to SQL Server using MS Access 2010
Posted by - NA - on 12 June 2010 08:06 PM
When connecting remotely, if an error like this appears:
Invalid Instance.Invalid Connection

with something similar to this in the event viewer:

*+* *System*
*-* *Provider*
[ *Name*] Microsoft Office 14 Alerts
*-* *EventID* 300
[ *Qualifiers*] 0
*Level* 4 *Task* 0 *Keywords* 0x80000000000000 *-* *
TimeCreated*
[ *SystemTime*] 2010-05-26T04:12:37.000Z
*EventRecordID* 18 *Channel* OAlerts *Computer* Matrix2
*Security*
*-* *EventData*
** Microsoft Access ** [DBNETLIB][ConnectionOpen (Invalid
Instance()).]Invalid connection. ** 502687

The following solution has been successful for previous clients:
-Try modifying the Data Source to "IPADDRESS,1433" replacing IPADDRESS with your server's IP address.


(40 vote(s))
Helpful
Not helpful
Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).