nV News Forums

 
 

nV News Forums (http://www.nvnews.net/vbulletin/index.php)
-   Software Development (http://www.nvnews.net/vbulletin/forumdisplay.php?f=53)
-   -   MySQL Connect Problem (http://www.nvnews.net/vbulletin/showthread.php?t=104340)

technoid 12-15-07 06:03 AM

MySQL Connect Problem
 
I created a small MySQL project on my personal ISP and after getting it going I tried to move it our server at work. I installed MySQL 4.1 and the 3.5 Connect Driver but I can't connect to the database. I keep getting the error below. I output the connect string so you can see how I'm trying to connect.

I installed HeidiSQL a freeware admin utility and can use it just fine. I created a table just like the one in the project on my personal ISP so MySQL seems to be installed and working correctly on the server itself. But I don't know enough about it to troubleshoot the connect problem. I've done a lot of google searches and it seems like my connect string is okay but I'm not sure about what to put in for the server. I put the normal url since that seems right, but maybe not. If anyone has any ideas on this I'd appreciate any help you can offer.

Quote:

Driver={MySQL ODBC 3.51 Driver};SERVER=http://omapsw-w-web.sc.ti.com;PORT=3306;DATABASE=sdpgroup;UID=root ;PWD=xxxx;OPTION=3;
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/cellularsystems/tools/test/mysql/inventory/sqlcon.asp, line 16


JOPS 12-15-07 07:05 AM

Re: MySQL Connect Problem
 
I've never used the driver you're using but I'm pretty sure "http://" shouldn't be there.

technoid 12-15-07 10:31 AM

Re: MySQL Connect Problem
 
Quote:

Originally Posted by JOPS
I've never used the driver you're using but I'm pretty sure "http://" shouldn't be there.

I should have said this before. I tried it with and without the http part. I'm connecting to it from a different machine so I thought the http part would need to be there. But I'm a beginner and don't know yet :)

I guess I could add something to my question above. Once the driver is installed do I have to go to the ODBC Data Source Administrator and create a System DSN? I'm trying to connect DSN Less so I didn't think I needed to, but maybe I do.

ViN86 12-15-07 11:24 PM

Re: MySQL Connect Problem
 
Quote:

Originally Posted by technoid
I created a small MySQL project on my personal ISP and after getting it going I tried to move it our server at work. I installed MySQL 4.1 and the 3.5 Connect Driver but I can't connect to the database. I keep getting the error below. I output the connect string so you can see how I'm trying to connect.

I installed HeidiSQL a freeware admin utility and can use it just fine. I created a table just like the one in the project on my personal ISP so MySQL seems to be installed and working correctly on the server itself. But I don't know enough about it to troubleshoot the connect problem. I've done a lot of google searches and it seems like my connect string is okay but I'm not sure about what to put in for the server. I put the normal url since that seems right, but maybe not. If anyone has any ideas on this I'd appreciate any help you can offer.

have you considered phpMyAdmin? it's placed on the server running the MySQL daemon. also, it requires PHP.

i have experience with that.

t3hl33td4rg0n 12-24-07 05:16 PM

Re: MySQL Connect Problem
 
Is this ASP?

If you're going to use ASP and ODBC, why not just use an Access db through DSN?

Then again it would be much easier to use Apache/PHP/MySQL, all are free and excellent development tools ;)


EDIT: And phpMyAdmin is an awesome MySQL db administration tool.


All times are GMT -5. The time now is 08:15 PM.

Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 1998 - 2014, nV News.