.NET WPF Browser(XBAP) sql server odbc sql.ini

[johnny]

sql server odbc

Win32 Application STandard EXE is Work OK.

but

NET Application

.NET WPF Browser(XBAP) Work Error Message:

Error Description: Unable to create a database connection. Check your connection string / or your sql.ini your settings

sql.ini save in where?

[npoursin]

I had the same error message under the same conditions but in Oracle. It came from that I did not have the correct version of Oracle client.

Nicolas

[Jeff Luther]

FYI, see this thread: https://support.guptatechnologies.com/supportforum/viewtopic.php?f=68&t=5947
for info. on the Oracle client(s) supported in v6.

[johnny]

SQL SERVER how to set ?

tks.

[Jeff Luther]

Sorry, giving you a forum link for Oracle didn't seem very helpful. I must have thought so at the time, though I don't know why now.

Re v6 XBAP and MS Sql Server: You had asked

SQL SERVER how to set ?

There are a couple steps to setting up connectivity to MS SS:

1) What version of MS SS? In .NET, v6 supports 2005 & 2008: http://www.guptatechnologies.com/Produc ... atrix.aspx

2) TD connects to MS SS via ODBC, to the first thing you need to do is set up an ODBC connection for your DB. I run Win. XP and use ODBCAD32.EXE:

JL_ODBC_ConfigUtility.png

You will see I have 2 MS SS ODBC connections, each using a different MS SS driver ("SQL Server" and "SQL Native Client").

3) In SQL.INI these sections must be set:
(uncomment comdll=sqlodb32, remove the ';')
[win32client.dll]
comdll=sqlodb32
...
[odbcrtr]
remotedbname=sqlsvr05,dsn=sqlsvr05
remotedbname=sqlst2k5,dsn=sqlst2k5

[johnny]

i get a problem !!

My Tests the platform
Win xp + TD6.0 sp1

when i compile TD source and run
I select the option "Win32 Application STandard "
and i setting up the sql.ini to connect ms sqlserver
it work and can select data !!
.
so I suppose sql.ini setting is correct

and then i choose the option ".NET WPF Browser(XBAP)"
it can run but when i click the button to connect database
it show the error message "Error Description: Unable to create a database connection. Check your connection string / or your sql.ini your settings"

.Which do I have make the mistake ??

and when i choose the option ".NET WPF Browser(XBAP)"
should i save sql.ini in special path??

[Jeff Luther]

when i choose the option ".NET WPF Browser(XBAP)"
should i save sql.ini in special path??

NO, you should not have to. SQL.INI should already be in the PATH and available.

[guptag]

Make sure you have Microsoft .NET Framework 3.5 SP1 on the machine.
If not it can be downloaded from http://www.microsoft.com/downloads/en/d ... laylang=en.

[johnny]

I write a program to connect MS SQL Server
i compile to XXXX.xbap
and path " wwwroot\AdoProxy " auto generation some .dll file like

IBM.Data.Informix.dll
Oracle.DataAccess.dll
Sybase.Data.AseClient.dll
Unify.SQLBase.Data.dll
Unify.TD.Runtime.Wcf.Server.dll

but i can't run the programe
it can't connect to sql server

I guess
it should have some dll file like " MSSQL.DATA.dll"

does it lost some file ??

[johnny]

local run is OK
but
not local run is not OK

[guptag]

Microsoft SQL Server driver for .NET is part of Microsoft .NET Framework. TD6.0 needs Microsoft .NET Framework 3.5 SP1.
Apart from .NET Framework 3.5 SP1 we need to create system dsn on server machine in order for succesful connection.