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
Hi All, let me know how to scan all from one internal table to another internal table. Pls provide me the syntax and code. i am very thankful to you all in advance. Thanks & Regards, Nagarjuna.if u want to copy data from itab1 to itab2  then use itab [More]
Hi,      I am able to see role types like plant,,Purchasing unit in T.Code BUSD,these roles are assigned to particulare category,For example role plant we can see in Organization only but not in person,Where we do these setting. And please give me me [More]
Recently had to uninstall and reinstall both LabVIEW 32 and 64-bit versions because the network administrator is dumb.  Now 32-bit works fine but the 64-bit version immediately crashes upon opening.  Getting the following Labview Crash: Exception: Un [More]
When I copy and paste a path from window explorer into teststand as a constant, I need to add an extra "\" in front of all the "\" manually.  Is there a quicker way?  Thanks! Kudos and Accepted as Solution are welcome! Solved! Go to So [More]
Hi friends, How to get email id of pa0001-pernr. Pls reply. Thanks in advance.Hi, See the below sample program. parameters p_pernr type PRELP-PERNR. data : v_date type sy-datum,        wa_data type p0105,        it_data type standard table of p0105. [More]
We are in the process of building a new house and have gotten to the point where we have to decide to wire for ENET or go wireless only. We have 2 Mac Pros, 3 MacBook Pros and several Gx Macs without wireless. The LAN will be used for internet and da [More]
When we will be getting Lumia denim update for Lumia 930? Will Lumia Denim bring 4G selection update for RM-1045_1032 - Lumia 930? Please reply for my queries.  Anybody could help me on this?Hello balawings, Welcome to our community. @ceroberts75 is [More]
Hi All,           Iam Getting the error for Parse Application Data -error ID: CX_ST_DESERIALIZATION_ERROR;  Pls check the log file.. xml version="1.0" encoding="UTF-8" standalone="yes" ?> - <!--  Call Inbound Proxy   -- [More]
Hu guys , This is my first paricipation in this forum , and I hope you are helping me out I have Xpress Music 5610 , and I've just updated through the update installer . However , I can not write in Arabic letters any more . The version of the update [More]
Hi all-- I'm new to the scripting thing and have been trying to learn but am getting nowhere. Wondering if anyone could help me. My current workflow is: Batch including all subfolders using an action that crops, levels, and adds a border then saves t [More]