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
Hello all,    I would like to have the window of clips for my events to be oldest to newest and not newest first. I see where I can arrange the selection of Event either by newest first or last, but I see nowhere that I can do this for clips in an ev [More]
I support an educational organization in the creation, layout, update and publication of a multi-page (between 8-15 pages) newsletter newsletter on a monthly basis. The layout changes every month depending on content. Updates come to me in all differ [More]
hi all, i have a trinidad table on my jspx page. I set the rows size to 5 inorder to prevent all records being displayed. when there are more than 5 records we can navigate using previous and next buttons. when we click next or previous button the re [More]
I installed some applications like fring,youtube,facebook.Yesterday i formatted my memory card so these applications gone,but the problem is i cant downoad again these applications from ovi store.can anybody help how to make it possible to re downloa [More]
Can we use the old block charger from 2004 to charge the new i-phoneAll USB chargers are 5 volts. The current supplied (and thus the power) does not matter, because the phone has a current limiter in it that assures that no more that 1 amp (5 watts) [More]
Want to know how to find the lock wait timeout set on Oracle 11gHi, To find number of seconds a distributed transaction waits for a lock: SELECT *   FROM v$parameter WHERE NAME = 'distributed_lock_timeout';To find all parameter's related to lock you [More]
I am not able to activate my 32GS phone after I download and installed OS5Generally that is a sign that the iPhone had previously been jailbroken or hacked to work with other than the original wireless provider. The update has relocked the iPhone to [More]
Hi, I would like to generate print preview of all the fields in the form dynamically when the user clicks a button. How do I make a pop up PDF form when the user clicks a button. The reason for not going for Adobe's print functionality is that I have [More]
Hi, How long will a free trial of Dreamweaver CS6 expire? Many Thanks & Best Regards, HuaMin     30 days. http://www.adobe.com/special/products/creativesuite/trial/faq/index.htmlRead other 2 answers [More]
I am trying to install a Firmware update on a PowerMac G5 1.6. I downloaded through Software Update. And follow the instructions that came with the updater but when I go to restart I get a completely different result than what I should. Instead of th [More]