Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Connection string problems

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
snowbird30ds Posted - 19 November 2020 : 08:02:16
I'm in the process of moving server to hostgator and struggling to get a connection, I have an existing access db, which connection string should I use? Attached is a pic of the odbc options I can setup.

Eventually I hope to go over to mysql so any help with that connection would be appreciated too, I've tried all options so far with no joy.
Thanks in advance.
Here are the server specs.
Windows Server 2016
Windows IIS 10
Plesk Panel 17.5 for Windows
MSSQL Server 2016 Web Edition
MySQL Server 5.6
MySQL Connector 5.3
Access Databases 2007, 2010
ASP Classic, ASP.NET 2.0, 3.5, 4.0, 4.5, 4.6 & 4.7
PHP 5.2.17 through PHP 5.6.39, PHP 7.0.33
Python, SSI (Optional)
cURL, GD Library, MVC 2.0/3.0/4.0/5.0, AJAX
AwStats, SmarterStats
MSFTP 10.0
URL Rewrite 2.0
SmarterMail Mail Server 15
5   L A T E S T    R E P L I E S    (Newest First)
HuwR Posted - 21 November 2020 : 09:36:52
You'll need to check with your host about that
snowbird30ds Posted - 20 November 2020 : 15:43:51
Found a setting in my user control panel to allow 32bit applications and it works!
Next...
I'm wanting to go over to mysql at some point and keep getting the following error when I change the config file for sql:
[MySQL][ODBC 5.3(w) Driver]Access denied for user 'ODBC'@'localhost' (using password: NO)
The 'forum' dsn setting connects ok when I test it in my control panel, what does this mean? How do you include a password in the string? This what I am sing to get this.
strConnString = "forum" '## DSN
HuwR Posted - 19 November 2020 : 18:00:41
yes sounds like it, classic asp is 32 bit and they probably have 6bit drivers installed
snowbird30ds Posted - 19 November 2020 : 08:58:44
Thanks Huw
I tried that but keep getting:
[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

A hunt around seems to suggest a 32/64 bit issue on the server, I have raised a ticket with them.
HuwR Posted - 19 November 2020 : 08:36:13
You should choose microsoft access driver, you would then use the 'connection name in the' config.asp file.

you will need to use this setting in config.asp and replace the name with the one you have created, make sure you comment out your existing connection and uncomment this one.

'strConnString = "snitz_db" '## DSN

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000 Version 3.4.07