473,404 Members | 2,195 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,404 software developers and data experts.

Connection string problem...

Hi,

Problem I have.

We are trying out a new MRP system from 'www.caliach.com'.
I am a web & database programmer, and usually code & maintain a large
MS Access App via a back-end MySQL Server. I am no stranger to
Connection strings, but this one has got me.

I installed their specific ODBC driver and created a DSN Called
OmnisODBC
The fields available in their ODBC driver are :

DSN Name = OmnisODBC
DSN Description =
User Name =
Password =
Data File = (C:\VisionDemo\Data\TrainingDemo.dfi)

I have completed all but the description field. The company then told
me to try retrieving data in MS Excel first and then work from there.
I managed to select the ODBC I created whilst in Excel, and got the
required data into a spreadsheet.

What I want to do is find the best way to retrieve this data into an
..asp web page.

How would the connection string look ?
Thanks

David
Jul 19 '05 #1
3 1141
Should be a common DSN connection string.
'from dlbjr

'Unambit from meager knowledge of inane others,engender uncharted sagacity.
Jul 19 '05 #2
Have you tried something as simple as:

"DSN=OmnisODBC;uid=userName;pwd=password" ?

James
Jul 19 '05 #3

Thanks everyone,

I've sorted the problem.
David
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: james | last post by:
I have written a generalised database access component which construct the connection string after decrypting its value using DPAPI methodology. But as i assign the enitre connection string to...
3
by: Job Lot | last post by:
I am connecting to my SQL database using following connection string Dim strSQL = "Persist Security Info=False;Integrated Security=False;database=myDA;server=myServerNane;User ID=;Password=" Dim...
3
by: bob | last post by:
Hi, I am trying to encrypt my connection string in the app.config file. I am using Base64 encryption, I just want to hide it from casual users. I keep getting file not found error. However...
3
by: William Gower | last post by:
I am converting an ASP app to ASP.net. I need to run the old asp app on my desktop in the process. I downloaded the files from the web server and set my connection string as follows strConn =...
3
by: Anthony Smales | last post by:
I'm trying to display an images directly sourced from a SQL Server dbase, and it would probably work but I can't get the connection string right! I have tried just LOBSTER and (local), but still...
6
by: Bala Nagarajan | last post by:
Hello, I am using Oracle 9i in my application and facing a problem with the connection string. In the datasource attribute of the connection string i had to specify an entry in "tnsnames.ora"...
1
by: Lorenzo | last post by:
I have a problem with oledb connection string of Mysql for .NET I installed MyOleDB3.exe Mysql server version 4.1.8-nt I used this connection string : ...
0
by: John | last post by:
Hi I am manually able to create a connection to my db in the vs2005 ide using Tools->Connect to Database. In the connection I see 'Data Source=MYSERVER;Initial Catalog=aspnetdb;Integrated...
2
by: shapper | last post by:
Hello, I am need to get a connection string details. I am doing as follows: 01: Dim connectionStrings As New ConnectionStringSettingsCollection 02: Dim connectionString As New...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.