[DBEETLIB}[ConnectionOpen(Invalid Instance()))

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
Mitchellhu
Posts: 3
Joined: Thu 22 Nov 2018 02:45

[DBEETLIB}[ConnectionOpen(Invalid Instance()))

Post by Mitchellhu » Thu 22 Nov 2018 03:22

Hi:
1.
SQLsever environment: OS:windows server 2016
Ms Sql Server 2008
2.
My Delphi Ver : Delphi Xe2 update 4
Devart MSSql DBExpress Ver :6.3.4
On Delphi IDE: DBSqlConnecton setting & parameters as bellow

SchemaOverride=%.dbo
DriverUnit=DBXDevartSQLServer
DriverPackageLoader=TDBXDynalinkDriverLoader,DBXCommonDriver160.bpl
DriverAssemblyLoader=Devart.DbxSda.DriverLoader.TCRDynalinkDriverLoader,Devart.DbxSda.DriverLoader,Version=16.0.0.1,Culture=neutral,PublicKeyToken=09af7300eec23701DriverAssemblyLoader=Devart.DbxSda.DriverLoader.TCRDynalinkDriverLoader,Devart.DbxSda.DriverLoader,Version=16.0.0.1,Culture=neutral,PublicKeyToken=09af7300eec23701
MetaDataPackageLoader=TDBXDevartMSSQLMetaDataCommandFactory,DbxDevartSQLServerDriver160.bpl
ProductName=DevartSQLServer
GetDriverFunc=getSQLDriverSQLServer
LibraryName=dbexpsda40.dll
VendorLib=sqloledb.dll
LocaleCode=0000
IsolationLevel=ReadCommitted
MaxBlobSize=-1
LongStrings=True
EnableBCD=True
FetchAll=True
ParamPrefix=False
UseUnicode=True
Database=Drsi_Stock
HostName=192.168.1.3
User_Name=sa
Password=u3sql@2007
PersistSecurityInfo=True

while I activate the sqlconnection , it raises an error :
SQL State:1, SQL Error Code:14, Level:16 Procedure , Line:0
[DBEETLIB}[ConnectionOpen(Invalid Instance()))

I don't have any idea about this error,
How to fix this problem!!!
Thanks

Sorry for my bad Englis ability, hope someone could help me!!!

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: [DBEETLIB}[ConnectionOpen(Invalid Instance()))

Post by Stellar » Thu 22 Nov 2018 13:53

Based on the error message, you are trying to connect to a non-existing instance of SQL Server. Please check the connection settings, you can also try connecting to the server using SQL Server Management Studio. Please let us know the results.

Mitchellhu
Posts: 3
Joined: Thu 22 Nov 2018 02:45

Re: [DBEETLIB}[ConnectionOpen(Invalid Instance()))

Post by Mitchellhu » Wed 28 Nov 2018 04:03

Hi Stellar :
Here are some pics for my Sql server and Db information;
1.Sql server and Db ===>open pic on the other page,pls
Image
2. Delphi ado connection information and testing result --> it is OK
Image
3. Delphi devart Dbexpress driver connection information and testing result --> it failed;
Image
Image
Image

sorry for my stupid operation about how to add pictures on this post, It took me a lot of times, and still can't show pics directly.

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: [DBEETLIB}[ConnectionOpen(Invalid Instance()))

Post by Stellar » Thu 29 Nov 2018 11:18

You can send us your question using the contact form at our site:
http://www.devart.com/company/contactform.html

Mitchellhu
Posts: 3
Joined: Thu 22 Nov 2018 02:45

Re: [DBEETLIB}[ConnectionOpen(Invalid Instance()))

Post by Mitchellhu » Thu 29 Nov 2018 12:25

Hi Stellar:
I send a new post by the contact form you provide!!!
thanks

Mitchell Hu

Post Reply