Page 1 of 1

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

Posted: Thu 22 Nov 2018 03:22
by Mitchellhu
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!!!

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

Posted: Thu 22 Nov 2018 13:53
by Stellar
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.

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

Posted: Wed 28 Nov 2018 04:03
by Mitchellhu
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.

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

Posted: Thu 29 Nov 2018 11:18
by Stellar
You can send us your question using the contact form at our site:
http://www.devart.com/company/contactform.html

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

Posted: Thu 29 Nov 2018 12:25
by Mitchellhu
Hi Stellar:
I send a new post by the contact form you provide!!!
thanks

Mitchell Hu