dbclient
Can anyone give suggestions on command line switches, etc..? I am trying to connect to a sqlanywhere database that is housed on a netware server. The connection is going over a WAN (through a router). I am using the "-x ipx". However the client is not finding the database server. I am able to log in to the netware server and look at the database file from the client machine. I am also able to connect to the server from a client machine that is located on the same segment of the WAN that the server is on. Any suggestions or clues would be greatly appreciated. Dav...

not connected when I am connected
What do I need to change on my 'puter when the icon in the toolbar shows and tells me I am connected and the error message tells me I am not and I can not go to web pages, get or send emails. I have to close down and restart to get connected again. This only happens if I am on line and leave the 'puter for an hour or so. As long as I am using it I don't have a problem. This just started about a month ago. I am on very slow dialup, DSL and Cable not in my area, thanks you SBC/ATT tks Elaine wrote: > What do I need to change on my 'puter when the icon in ...

Problem connecting with DNS-less connection string (using ASP)
My connection works if I connect using the DSN, the connection string being: "DSN=SybaseAdminDev;username=sa;password=intershop" but if I try using a DSN-less connection string: "Driver={Sybase System 11}; Server=ISSERVER; Database=sybsystemprocs; UID=sa; PWD=intershop" I get the error: --------------------------------------------- Microsoft OLE DB Provider for ODBC Drivers error '80004005' [INTERSOLV][ODBC SQL Server driver]Insufficient information to connect to the data source. /sybasetest/getDBsizes.asp, line 13 --------------------------...

DSN Less connection using sql anywhere
Hi We have recently shifted our web pages and asp pages onto SBC webhosting. The problem is that we are using SQl Anywhere 5.5 database on our database server. Our various locations are accessing asp pages using SQL anywhere database. I have to setup ODBC connection to SBC site . Currently we are using the following script in asp pages: Set conn = Server.CreateObject("ADODB.Connection") conn.Open "DSN=WestSac;UID=DBA" Set cmd = Server.CreateObject("ADODB.Command") Could anyone help me how to setup DSN less connection using SQl anywhere. Thanks N...

Can I use DSN less to connect database
Hi, Can I use DSN less to connect database, like connect to *.mdb? from LEO ...

Deploying ASA6 and using DSN-less connections...
Hi, After much research and trial and error, I have come up with a method of easily deploying ASA6 with my PowerBuilder 5 application (I would imagine all would still work with higher versions as well) and also of connecting to my ASA database without creating an ODBC Data Source (DSN). I noticed that this topic is asked about frequently, but I was unable to find a simple solution so I'd lke to contribute this one. I have tested this method on my Windows 95, 98 and 2000 environments, with complete success. If you have any comments about my method, please pass them along. ...

app.config connection string not being read
I have a Web app that has a UI Website Project and a DB dataset/db project. I am running SQL Server 2005 Express on my localhost for development purposes. I have the connectionstring for the DB in the DB projects app.config. The site is running perfectly on my localhost, but when I deploy the site to the review server and change the app.config's connectionstring accordingly a connection to the DB cannot be established. I then tried changing all the db names, usernames, password to jibberish in my app.config file on my localhost and running AND THE SITE STILL RAN ON LOCALHOST. For so...

connecting using a trusted connection
Hello, I appologize if this is in the wrong spot, but it seemed like the appropriate place. We have IIS installed on one box and SQL on another. We use a trusted connection to connect. When we try an connect to our DB, we don't get an error, the page just refreshes. From what i have gathered, it looks like we are not being authenticated. We have the ASPNET domain user on both boxes and its configured with the correct permissions, but we still can't connect. Do i need to set up or give permissions to another account i dont know about, or is there some file that needs access?-Dev Dj...

Deploying ASA6 and using DSN-less connections... #2
Hi, After much research and trial and error, I have come up with a method of easily deploying ASA6 with my PowerBuilder 5 application (I would imagine all would still work with higher versions as well) and also of connecting to my ASA database without creating an ODBC Data Source (DSN). I noticed that this topic is asked about frequently, but I was unable to find a simple solution so I'd lke to contribute this one. I have tested this method on my Windows 95, 98 and 2000 environments, with complete success. If you have any comments about my method, please pass them along. ...

How to make a DSN-less connection using TSQLConnection in XE2
I'm sorry if this is off-topic. I'm actually trying to use DbExpress TSQLConnection to make a dsn-less connection via Odbc to various databases but mostly to Sybase SQL Anywhere 11 or 12. I couldn't see any other forum specifically for DbExpress. It's taken me a long time to get round to converting from Delphi 2007 to XE2 Enterprise, which I bought some time ago. I was using OdbcExpress before in d2007, but that is now obsolete and I thought I'd switch to DbExpress. However, I am quite disappointed with the way DbExpress is setup, as it seems to lean heavily on an INI fi...

DSN less connection using Web.config file
Hi I have added name value pair for connection string in the Web.config file as shown below. <appSettings> <add key="EventCM_Database" value="Provier=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=E:\web\keydynamics\htdocs\_database\db.mdb" /> </appSettings> On my local environment if works file when the file is located within c:\Inetpub\wwwroot\Applicationname\ directory I attempt to access the database in the following manner and it works on my local environment. Dim dbConnection As System.Data.IDbConnection = N...

DSN-less, register-less connection?
I have the DSN-less connection ok with the following: SQLCA.DBParm = "ConnectString='Driver=Adaptive Server Anywhere 7.0;" + & "UID=dba;PWD=sql;DBF=c:\mydir\mydb.db;" + & "Start=c:\mydir\rteng7.exe -c 8m'" But as far as I know the 'Driver=Adaptive Server Anywhere 7.0;' requires a register setting, or does it? Can I get around this somehow so I don't need any register settings for a connection? "Doogie" <doogie@anywhere.com> wrote in message news:OWG942%23NDHA.364@forums-2-dub... > I have the DSN-...

REPOST: PB components use only 1 connection from 50 connections connection cache
Hello all, I'm currently investigating a performance bottleneck in jaguar. I've reported this problem before and got some helpful hints from this forum so I'm back for more, since the hints weren't helpful enough. I have a web application which uses Powerbuilder components as the backend. Even when I generate 30 calls that each take 1 minute, the Jaguar server reports that it uses only one connection!! When I check oracle, it reports that only one session is active from the Jaguar server. Now I can just handle this if it was only one session but when i teste...

ODBC DSN less connection issues using ASE ODBC Driver
Hi, I am facing a problem while making dsn less connection to sybase Here is the thing, I shall try to make it simple: this piece of connection string works fine in production with sybase 11 open client installed Driver={SYBASE SYSTEM 11};Srvr=SYBPRD_DEV;Uid=SYBPRDCOM;Pwd=welcomedb1; However, I am trying to setup a Dev environment with Sybase open client 12.5 ..this piece fails with the following error msgs, Connection string: err msg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (i tried changing it to {SYBASE ASE ODBC Drive...