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
/ I am the president of a web development firm who uses Skype and a Creative webcam to communicate with our clients around the world. This morning, we had to re-load our computers' OS because of some issues we were having, and when I went to look for [More]
Hello Experts, I am working on SRM as add-on to ECC. When I am trying to migrate vendors from ECC to SRM using MDS_LOAD_COCKPIT. Within monitor, all queues are 'green' indicating that data has successfully migrated to SRM. But when I check vendors in [More]
how do i download my ipodnano songs to my ipad2can you tell me where ti s option is ? RegardsRead other 6 answers [More]
Hello, I want to post Customer TDS. I have configured Vendor TDS and I am able to post withholding tax entries successfully. It seems that the entire setup for the Customer TDS remains same. While assigning Withholding Tax types to Company Code, I ha [More]
Hi everyone! I installed gnome 3.2 from unstable, and I notice that now my power management is worst than ever. The problem is that my graphics card, nvidia nvs 3100m, has some problems with DPMS. I can set the screen off with dpms, It works, but mou [More]
Hi all... I'm trying out on this piece of code that reads the HTML file and then display it in a JEditorPane. Problem is, seems like I'm unable to create a new URL file?? Here's part of the code:      private JEditorPane createEditorPane(String htmlN [More]
My iPod Touch used to work seamlessly until 2 days ago, the following error message appeared everytime I plugged my iPod Touch into my laptop: MobileDeviceService has encountered a problem and needs to close. We are sorry for the inconvenience. The e [More]
If they fit right, are they better than the earbuds, or Fontopias? How do they compare to the competition?They fall out all the time despite trying the different rubber tips. The sound is much better than the earbuds with a fairly solid bass sound bu [More]
Ok. So I just got a new iPod Touch 4th generation for Christmas :). And my old one is a 1st generation. And recently the computer I used iTunes with my 1st generation, crashed. And i'm using my other laptop but it doesn't have the saved stuff. And I [More]
I'm interested in using a public SLES11 image but have reservations about the issues posted here. Amazon Web Services Developer Community : Problem starting novell based but ... Has there been a resolution or Novell response to this claim? ari-d98c6c [More]