da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Error Code 0014???

Forum List » AnyDAC » v 1.x General English

gymwalker
User

Senior Boarder

Posts: 23

Karma: 0

Error Code 0014???

Posted: 2005/07/12 09:50

All of a sudden I'm getting this error code saying Invalid Connection and Connection Open Invalid Instance...what went wrong? I don't think I changed anything...what should I check?

I had some System DSN's set up for the remote database (accessing via VPN connection)...and they disappeared...so I re-built them...but I'm still getting the error and I'm not sure what else to do?

I'd be grateful for any help you could give!

Thanks in advance!

Jim Walker
J. Walker Consulting
951-970-6030

Diman

Admin

Posts: 1495

Karma: 19

RE: Error Code 0014???

Posted: 2005/07/12 15:15

Hi !

Let start from:
1) What DBMS do you use ?
2) What exact error message you are getting ?

Regards,
Dmitry

gymwalker
User

Senior Boarder

Posts: 23

Karma: 0

RE: Error Code 0014???

Posted: 2005/07/12 20:15

The DBMS is MSSQL...

The Exact Error Messages are...

[AnyDAC][Phys][ODBC][Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.

and...

SQL state: 01000. Native error: 14. Error message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid Instance()).

Hope this helps!

Thanks again!
Jim

Diman

Admin

Posts: 1495

Karma: 19

RE: Error Code 0014???

Posted: 2005/07/13 11:22

Hi !

1) What value Server parameter has ?
2) If you use alias, then check it is correct.
3) If server IP is changed, then check you use right IP or server name in Server or alias setup.

etc.

Regards,
Dmitry

gymwalker
User

Senior Boarder

Posts: 23

Karma: 0

RE: Error Code 0014???

Posted: 2005/07/16 01:12

Problem Solved...it was along the lines of your first suggestion.

It was the Server NameInstance Name...

I had just been using the Server Name (i.e., ECOMSQL) instead of ServerInstance (i.e., ECOMSQLECOMSQL)...once I started using both...problem went away.

the reason the problem didn't occur originally is because I had DSN's set up for them correctly as ECOMSQLECOMSQL...then when I had the networking truble...my DSN's got blown away and I had to re-set them up...and that is when I set them up as just ECOMSQL...

I alos figured out during this process, I didn't need the DSN's at all.

It's all good!

Thanks for your help!
Jim

Forum List » AnyDAC » v 1.x General English