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

General discussion forum about all databases other than SqlBase.
johnny

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

Post by johnny » 24 Dec 2010, 03:07

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

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

Post by npoursin » 24 Dec 2010, 10:11

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

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

Post by Jeff Luther » 28 Dec 2010, 01:04

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

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

Post by johnny » 04 Jan 2011, 06:27

SQL SERVER how to set ?

tks.

Jeff Luther

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

Post by Jeff Luther » 04 Jan 2011, 20:53

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
You do not have the required permissions to view the files attached to this post.

johnny

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

Post by johnny » 05 Jan 2011, 08:36

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

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

Post by Jeff Luther » 05 Jan 2011, 21:40

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

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

Post by guptag » 06 Jan 2011, 01:23

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

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

Post by johnny » 13 Jan 2011, 10:15

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

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

Post by johnny » 11 Feb 2011, 09:55

local run is OK
but
not local run is not OK
You do not have the required permissions to view the files attached to this post.

guptag

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

Post by guptag » 15 Feb 2011, 18:32

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.

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests