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
So I've had two techs out to check the box outside my house where the wire comes in from the pole.  The problem is I cannot get HD TBS, TNT, Fox Sports 1, Comedy Central and many other channels.  These channels come in over the frequency that kicks o [More]
How can I change or set the default folder in iPhoto where I import pictures from my iPhone4.This is a long shot but try this: 1 - go to your System/MobileMe preference pane and log out of your MMe account. 2 - try logging in with a bad user name and [More]
I construct a failover cluster(file server,AP module) for sharing files by WSS 2012,and I want to use the shadow copies to backup my data,but when making  a shadow copies on the volume which  is added to the cluster(not the CSV,just add it to the clu [More]
Hi all, I'm trying to use iPhoto musics/songs into iMovie enviroment but I was unable to find them. Is someone aware if this is possible ? Clicking on Music icon in iMovie I can see all the musics/songs I have in my MAC but not the iPhoto ones ... Th [More]
Volunteered to create a high school football highlight video using Premiere Pro CS3 on a Mac.  The video will be shown in a banquet hall using a NEC projector attached to the ceiling.  The hall owner doesn't have any info on the projector, so I don't [More]
Summary: Does any one know how to get a JVM to be shared across different Windows processes, as follows: Context: I have created a Java ActiveX component. This is instantiated and used as an object embedded in HTML. The HTML will always be executed i [More]
There are a couple of issues that I'm seeing that I can't get a straight answer from anyone I talk to at Verizon either on the phone at a store. 1 - Battery Life: I'll typically give my phone a full charge overnight. If, starting around 8:00 AM, I ha [More]
I've just taken the plunge and converted all my CR2 images to DNG, replacing the originals. However, I still have all the JPEG sidecar files left over. Can I safely delete these, or are they required by the DNG? Also, I was previously using the optio [More]
This happens in the icloud.com interface.  I try and remove the checkmark beside several of my calendars, leaving only one visible.  All stay hidden except the one that is shared to me by another iCloud member.  That calendar keeps unhiding itself an [More]
My Macbook Air recently went in for repairs and got a near-total refurbishing (thanks Apple!)-new logic board and new SSD drive. When I went to restore it, it turns out that my network-attached drive (on an AirPort Extreme) was NOT creating a reliabl [More]