Sitemap

Amicuk Programming Answers

ODBC DSNless connection

2015-10-11   Views:0

Advertisement

I created some ASP pages for a database and while onmy local machine everything was good. When uploaded to my host the connection failed and they suggested a DSNless connection, i reasearched it on the net and there were several tutorials but none of

I created some ASP pages for a database and while onmy local
machine everything was good.
When uploaded to my host the connection failed and they
suggested a DSNless connection, i reasearched it on the net and
there were several tutorials but none of them worked.
The current connection is
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
var MM_tracks_STRING = "dsn=tracks;"
and the link on the ASP pages is
<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/tracks.asp" -->
<%
var rstracks_cmd = Server.CreateObject ("ADODB.Command");
rstracks_cmd.ActiveConnection = MM_tracks_STRING;
rstracks_cmd.CommandText = "SELECT * FROM tracks ORDER BY
Suburb ASC";
rstracks_cmd.Prepared = true;
var rstracks = rstracks_cmd.Execute();
var rstracks_numRows = 0;
%>
Can anyone help me modify this to get it working?

The replay answer
Advertisement
replace this:
<!--#include file="Connections/tracks.asp" -->
With this:
<%
Dim MM_tracks_STRING
MM_tracks_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\SomeFolder\SomeDatabase.mdb;"
%>
Be sure to keep the MM_tracks_STRING = line on one line
Ken Ford
Adobe Community Expert
Fordwebs, LLC
http://www.fordwebs.com
"XaeroRamirez" <[email protected]> wrote in
message news:eto73e$29c$[email protected]..
>I created some ASP pages for a database and while onmy
local machine everything
> was good.
> When uploaded to my host the connection failed and they
suggested a DSNless
> connection, i reasearched it on the net and there were
several tutorials but
> none of them worked.
> The current connection is
> // FileName="Connection_odbc_conn_dsn.htm"
> // Type="ADO"
> // DesigntimeType="ADO"
> // HTTP="false"
> // Catalog=""
> // Schema=""
> var MM_tracks_STRING = "dsn=tracks;"
>
> and the link on the ASP pages is
> <%@LANGUAGE="JAVASCRIPT"%>
> <!--#include file="Connections/tracks.asp" -->
> <%
> var rstracks_cmd = Server.CreateObject
("ADODB.Command");
> rstracks_cmd.ActiveConnection = MM_tracks_STRING;
> rstracks_cmd.CommandText = "SELECT * FROM tracks ORDER
BY Suburb ASC";
> rstracks_cmd.Prepared = true;
>
> var rstracks = rstracks_cmd.Execute();
> var rstracks_numRows = 0;
> %>
>
> Can anyone help me modify this to get it working?
>

Go to See the other 6 answers

ODBC DSNless connection

Category:DefaultRelease time:2015-10-11Views:130

I created some ASP pages for a database and while onmy local machine everything was good. When uploaded to my host the connection failed and they suggested a DSNless connection, i reasearched it on the net and there were several tutorials but none of[More]

Using Password with DSNless connection to Access DB

Category:DefaultRelease time:-0001-11-30Views:130

Has anyone actually used a password to connect to a local Access database? I keep getting the "Not a valid password" error. I have created an application for distribution and do not want to allow the users to change my database, so I put a passw[More]

Automatically create ODBC DSN connection with special port and password. Add-OdbcDsn cmdlet

Category:DefaultRelease time:2015-10-11Views:130

Hi, I first posted a question in the SQL forum but I'm posting it here instead because its a Powershell question. In a non-persitent VDI enviroment we are trying to automatically create a ODBC DSN connection to a SQL server. We are using Windows 8.1[More]

ODBC (RDO) Connection Information : DataBase Server ID Greyed out

Category:DefaultRelease time:2015-10-11Views:130

Post Author: Eany CA Forum: Data Connectivity and SQL When I select the refresh option (Crystal XI) for a report which previously worked fine, I get sent to the ODBC (RDO) connection Information screen. The first box for Server ID is greyed out. When[More]

Crystal Reports and ODBC (RDO) connection

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm using SQL Server 2005 and Crystal Reports 2008. I connected my Crystal Report to the SQL database using an ODBC (RDO) connection. In the past I was able to add a field to a table in the database, and I was able to see the new field immediatel[More]

Dreamweaver & DSNless connection

Category:DefaultRelease time:-0001-11-30Views:130

Dreamweaver & DSNless connection I am fairly familiar with Dreamweaver and creating static web pages. However this is my first attempt at a dynamic webpage and I have hit several hurdles. First I setup a DSN connection...but was later told by my host[More]

JDBC ODBC bridge connections using 2.1.1

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have reviewed a lot of postings related to JDBC and third party drivers and understand how to connect to the packaged drivers such as MySQL and MS SQL Server/Sybase. Where I'm stuck is the reference in the Connections help to JDBC. We have a OD[More]

JDBC-ODBC-Bridge connection to SQL Database

Category:DefaultRelease time:-0001-11-30Views:130

Hi guys I have a problem. I've made a little game which I want to put on my website. It has a highscore-list which I want to connect to my web host's database server to get the current list. I tried this with JDBC and got it to work locally but when[More]

Informatica Workflow Manager ODBC Relational Connection for ETL in DAC

Category:DefaultRelease time:-0001-11-30Views:130

In Informatica Workflow Manager, I have created a Relational Connection of type ODBC and specified Connect String as "DSN=BIEEDW" where "BIEEDW" is the System ODBC DSN already set pointing to a SQL Server 2008 database. However, when t[More]

Using Oracle ODBC Gateway connecting to a remote Oracle database

Category:DefaultRelease time:2015-10-11Views:130

Oracle 11gR2 RHEL 6.4 Has anyone use the Oracle ODBC Gateway to connect to another Oracle database?  Any issues with that configuration?  Where do I get the ODBC drivers for Linux? (I know, "why not use a dblink?" -- well that would be against c[More]

ODBC Error connecting to a stored procedure SQL Server 2008 - Crystal 8.5

Category:DefaultRelease time:2015-10-11Views:130

I am running a local copy of SQL server 2008 and get an ODBC error when connecting to any stored procedure with or without parameter. The database are running in SQL Server 2000 compatibility mode on the local server. Do not get the error when connec[More]

Hot
BI Experts - I am using BI as my data repository to move data from R/3 to BPC. Any suggestions on what I need to look out for? Thanks.Purpose An important aspect in ensuring the quality of data in BI is the consistency of the data.  As a data warehou [More]
hi, I'm Trying to Install an SDK component from archive file into DS. I Follow the "Developer Guide: Design Studio SDK" and receiving the fallowing error: Failed to discover all connectors. RepositoryDiscoveryStrategy failed with an error Failed [More]
I have just tried updating my credit card details on my ITunes account using my IPhone. Once entered, it still prompts me to update my details saying my credit card is expired (even with a new expiration date of 2016!!). Why is this and how do I fix [More]
I am a blind iPad Mini user looking for the correct gestures for using the Numbers App with VoiceOver. I am not understanding how to navigate the spreadsheets or make changes in them.  Does anyone know of a good resource for this? All the ones I have [More]
Is the a way, when iPhone downloads my e-mail from my office via POP, to filter out unwanted messages or not download certain messages? I'd rather not download e-mail from a tech listserv I'm on, which can mount up and I'd rather check when I get bac [More]
I need to know how many lines are empty in a pdf file that my program is creating. The idea is that I read some data from a file. The amount of data is everytime different, varying from one page to twenty. I build a pdf file with this data and also i [More]
Hi Can anyone tell me how to handle national character set datatypes in oracle? Thanks in advanceAnd for data manipulation, append "N" the literal values being used in the command. The "N" indicates that the string is to be treated as [More]
In 11g URM, the documentation references the ability to create a custom disposition action by accessing one of the pre-defined services and passing parameters. Unfortunately I can not find documentation stating what the parameters are for each of the [More]
Hi, i have created SQL Server High Availability Group with listener.  Now Cluster, machine, and listener IP have changed. pls guide me step how to updated all IP Cluster, and HA availability listener. thx  iffiHi imughal, As your description, you wan [More]
Hi , There the problem. I got 2 songs with .aac extension cannot play and add to library . I'm using the latest itunes 10.6.3.25 and window 7. Can anyone show me how to check whether a song is DRM-free or not.Are you adding them by: Opening iTunes Go [More]