nks in Advance.
>
> Regards,
> Narasimha
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 04, 2004 11:00 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Database Connection using DSN
>
> Hi.
> Se
ll databases appear nearly the same by creating a common interface
on one side of a driver and mapping that interface to the specific
requirements of each database system within the driver itself.
If you want to make an ODBC connection (because you insist, for some
reason, that you must create a
lto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 11:00 PM
To: [EMAIL PROTECTED]
Subject: Re: Database Connection using DSN
Hi.
See:
http://dev.mysql.com/doc/mysql/en/ODBC_Connector.html
When you call mysql_real_connect you use mysqlclient library,
which connects to server directly (you don'
Hi.
See:
http://dev.mysql.com/doc/mysql/en/ODBC_Connector.html
When you call mysql_real_connect you use mysqlclient library,
which connects to server directly (you don't need to configure ODBC).
To connect using DSN, you should use ODBC API. ODBC and MySQL
are completly different t
Hi,
I would like to know how to connect to the mysql database using a
DSN in mysql API's. I am using myodbc 3.51 driver.
Used the following API code for the connection
MYSQL *link = mysql_init(NULL);
MYSQL *connectHandle =
mysql_real_connect(link,"localhost",&qu
Just the fact that you GOT the gibberish meant that the server was running
and that you were able to connect. What you saw was a "Hello" packet. It's
one of the first stages to authenticating a MySQL client to a MySQL
server. It's not meant for humans.
Shawn Green
Database Administrator
Unimin
On Fri, 15 Oct 2004 11:36:23 -0600, Steve Grosz wrote:
> I also get the jibberish, and a connection lost error message. Is it
> something in MySql server that I'm not setting up correctly?
That probably means you can reach the MySQL server and the problem is
on OSI-layer 5-8 :-)
Could you go int
Did the gibberish look something like this?
Trying web-server2...
Connected to web-server2.
Escape character is '^]'.
:
4.1.4a-gamma
P--=)TK],rFDbDid:5:di
Bad handshakeConnection closed by foreign host.
If so, you got through to the mysql server. (See the version number?)
Y
I also get the jibberish, and a connection lost error message. Is it
something in MySql server that I'm not setting up correctly?
Jochem van Dieten wrote:
On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote:
Ok, with leaving the : off the end, and just typing telnet web-server2
3306 I get some
On Fri, 15 Oct 2004 10:26:22 -0600, Steve Grosz wrote:
> Ok, with leaving the : off the end, and just typing telnet web-server2
> 3306 I get some jibberish on the screen, and a 'connection lost' message
> after a few seconds. That's coming from a machine on the same side of
> the firewall as the S
Ok, with leaving the : off the end, and just typing telnet web-server2
3306 I get some jibberish on the screen, and a 'connection lost' message
after a few seconds. That's coming from a machine on the same side of
the firewall as the Sql server. For the other IIS server and Coldfusion
server
On Thu, 14 Oct 2004, Dwalu Z. Khasu wrote:
=>Neither the DOS nor Unix man pages for telnet mention a colon--Why do you
=>think you need one? Let me try again, how about 'telnet web-server 3306'?
=>
Sorry for the typo. For your example, that should've been:
telnet web-server2 3306
Are you sure
On Thu, 14 Oct 2004, Steve Grosz wrote:
=>I have tried telnet web-server2:3306
=>
=>Didn't work
=>
Neither the DOS nor Unix man pages for telnet mention a colon--Why do you
think you need one? Let me try again, how about 'telnet web-server 3306'?
...
...
=>Dwalu Z. Khasu wrote:
[snip]
=>> =>
=>>
Did you tried without the : between web-server2 and 3306?
i.e. put a space insted of :
B
On Thursday 14 October 2004 19:58, Steve Grosz wrote:
> I have tried telnet web-server2:3306
>
> Didn't work
>
> Dwalu Z. Khasu wrote:
> > On Thu, 14 Oct 2004, Steve Grosz wrote:
> >
> > =>If that's the cas
2004 9:29 AM
To: [EMAIL PROTECTED]
Subject: Re: Adding DSN into Coldfusion Admin?
I have tried telnet web-server2:3306
Didn't work
Dwalu Z. Khasu wrote:
> On Thu, 14 Oct 2004, Steve Grosz wrote:
>
> =>If that's the case, its not working, I type a telnet
192.168.x.x:3306
> =&g
I have tried telnet web-server2:3306
Didn't work
Dwalu Z. Khasu wrote:
On Thu, 14 Oct 2004, Steve Grosz wrote:
=>If that's the case, its not working, I type a telnet 192.168.x.x:3306
=>and get a "could not open a connection to the host" even though
=>Mysql-nt shows as running on the Win2003 serv
On Thu, 14 Oct 2004, Steve Grosz wrote:
=>If that's the case, its not working, I type a telnet 192.168.x.x:3306
=>and get a "could not open a connection to the host" even though
=>Mysql-nt shows as running on the Win2003 server.
=>
=>Steve
=>
Try 'telnet host port'.
Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz <[EMAIL PROTECTED]> wrote:
I am new to using MySql. I installed it on a seperate server on
Win2003. That server has a 192.168.x.x address on my network.
I am trying to add a DSN connection from Coldfusion to the database, but
every time I try us
as a 192.168.x.x address on my network.
I am trying to add a DSN connection from Coldfusion to the database, but
every time I try using the MySql driver/connection type, it says there
doesn't seem to be a server running at 192.168.x.x:3306
What am I doing wrong? How can I check remotely to see if t
telnet to it. MySQL will return a 'hello' packet.
-Eric
On Thu, 14 Oct 2004 12:37:08 -0600, Steve Grosz <[EMAIL PROTECTED]> wrote:
> I am new to using MySql. I installed it on a seperate server on
> Win2003. That server has a 192.168.x.x address on my network.
>
&
I am new to using MySql. I installed it on a seperate server on
Win2003. That server has a 192.168.x.x address on my network.
I am trying to add a DSN connection from Coldfusion to the database, but
every time I try using the MySql driver/connection type, it says there
doesn't seem to
Thanks OGINO San.
You are right.
I am using MySQL API. So, I need to connect thro' hostname,
databaseName, etc. only and not thro' the ODBC DSN.
-Original Message-
From: OGINO Tomonori [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 14, 2004 9:57 PM
To: [EMAIL PROTECTED]
S
In message <[EMAIL PROTECTED]>
"'mysql_real_connect' with DSN "
""Nawal Lodha" <[EMAIL PROTECTED]>" wrote:
>
> Can 'mysql_real_connect' be called using DSN name rather than giving
> hostname, database name, port n
Hi All,
Can 'mysql_real_connect' be called using DSN name rather than giving
hostname, database name, port no., etc ?
Thanks,
Nawal.
Is the MyODBC driver installed on the Webserver? Without it, you will
still encounter this error message.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 2/5/04, 9:05:51 A
The ISP do have the driver installed and they also know what they are
talking about. The problem is they won't talk to me because I am not
the reseller (ie their customer). The reseller I have used knows
nothing about MySQL - he knows everything else but MySQL.
Mat
On Thursday, February 5, 2
ore opening any attachments.
-Original Message-
From: Matthew Stuart [mailto:[EMAIL PROTECTED]
Sent: 05 February 2004 13:50
To: MySQL email support
Subject: Need DSN less help
I am having problems with making a connection between my website and
the MySQL db on a different server. I
I am having problems with making a connection between my website and
the MySQL db on a different server. I have tried both hand coding and
using the MyOLEDB application for MySQL. What am I doing wrong? If you
think this looks a little strange, it is because it is a dreamweaver
connection file.
PROTECTED]]
Sent: Sunday, 26 January 2003 2:33 PM
To: '[EMAIL PROTECTED]'
Subject: Needed: Working VB6 example of DAO DSN LESS connection using
MyODBC to MySQL preferably with passthruquery
This message intended for MyODBC questions list.
Hello VB6, MySQL, and DAO developers,
A v
ompt, False , str)
'this last line errors with
' -- Run-time error '3146' - ODBC--Call Failed.
'if I use:
' Set conn = ws.OpenConnection("test", dbDriverPrompt, False , str)
'and just select OK on the ODBC Connection Manager
'
998/11/0/56625
>
> I have discovered that I can create a trimmed-down version using notepad:
>
> [ODBC]
> DSN=foobar
>
> If I call this file foo.dsn and put it in "C:\Program Files\Common
> Files\odbc\Data Sources", foo.dsn shows up in the ODBC Data Source
> A
rsion using notepad:
[ODBC]
DSN=foobar
If I call this file foo.dsn and put it in "C:\Program Files\Common
Files\odbc\Data Sources", foo.dsn shows up in the ODBC Data Source
Administrator application (aka ODBC manager). However, in order to
actually use it, I have to create the Sys
Hello all,
Why can I not create a File DSN using MyODBC 2.50.39 on Windows 2000?
I have installed MySQL v3.23.52-max-nt and MyODBC 2.50.39 on a Windows 2000
machine. While I can create both System and User DSNs, I cannot create a
File DSN. When I try I get the error message "File Data S
sion.
>i planned to do the installation by using install shield to one short doing
>the
>mysql, myodbc installation and also the ODBC DSN setting.
>
>is anyone have any idea to do the ODBC DSN setting through install shield ?
>or writing any programs/script to make it work ?
>
&g
Hi, i am doing a project and it is almost nearing release version.
i planned to do the installation by using install shield to one short doing
the
mysql, myodbc installation and also the ODBC DSN setting.
is anyone have any idea to do the ODBC DSN setting through install shield ?
or writing any
iver] Can't connect to MySQL
> > server on 'hostname'
> > (10061), then after clicking ok, the DSN Configuration Dialog
> > is opened, but
> > hidden behind the application window. In contrast, on Windows
> > 2000, no error
> > message box or dsn
Hi ,
> -Original Message-
> From: mySQL list [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 07, 2002 2:35 AM
> To: [EMAIL PROTECTED]
> Subject: MyODBC DSN Configuration Dialog Hidden
>
>
> Hi,
>
> I have a vb application which connects to mysql via
, not
Windows 2000: If I try and connect to a host where mysql is not running, the
driver (or at least I assume its the driver), pops up an error message box,
saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname'
(10061), then after clicking ok, the DSN Configur
> Hello,
>
> Can anybody here help me.
>
> I have a MySQL server running on Linux to which I wish to connect from a
> machine running NT. This is fine normally using
> MyODBC.
>
> However the following scenario does not work.
>
> The DSN is a file DSN on ano
Hello,
Can anybody here help me.
I have a MySQL server running on Linux to which I wish to connect from a
machine running NT. This is fine normally using
MyODBC.
However the following scenario does not work.
The DSN is a file DSN on another NT box and is accessed using UNC e.g.
//machine
I believe your provider must be a valid db drivermake sure it exists on
your machine.
you may want to check out www.4guysfromrolla.com they have a great section
on asp dsn/dsn-less connections.
Hope it helps.
Darren S. Ball
Software QA Engineer
Lucent Technologies - InterNetworking Systems
sage -
From: "GRC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 9:43 PM
Subject: making a dsn-LESS connection
> I wish to have my asp pages (on an NT 4.0 iis 4.0 machine) connect to a
> mysql database.
> I want to have
I wish to have my asp pages (on an NT 4.0 iis 4.0 machine) connect to a
mysql database.
I want to have the DSN-LESS type of a connection.
This DSN version works:
ConnectionString = "DSN=myDSNname;User Id=myuserid;Password=aword;"
However this DSN-less version does not:
Connec
Hi Kevin,
> -Original Message-
> From: Kevin Smith [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 26, 2001 9:25 AM
> To: [EMAIL PROTECTED]
> Subject: MyODBC: DSN Creation
>
>
> Hi All,
>
> I need to setup MyODBC DSN's for MySQL access.
>
&g
Hi All,
I need to setup MyODBC DSN's for MySQL access.
Does anyone know how to build a simple installer that will create
User/System DSN's from a file? ie. like the odbc.inf file included with the
MyODBC installer?
Can odbcconf.exe be used to install a DSN? If so, what are the
Hi !
> -Original Message-
> From: Sylvain Hamel [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 5:34 PM
> To: [EMAIL PROTECTED]; MySQL Mailing list
> Subject: Re: DSN-Less connections using MyODBC?
>
>
> Hi Venu,
>
> > It doesn't depend
parser recognizes them
correctly when I use a dsn connection. If the driver wasnt loaded properly
shouldn't it crash also on a DSN connection? Like I said it works fine for a
DSN connection but not for a DSN-LESS connection. I also assume my program
is ok since it works with an Access97 database. I
Hi !!!
> -Original Message-
> From: Sylvain Hamel [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 2:26 PM
> To: MySQL Mailing list
> Subject: Re: DSN-Less connections using MyODBC?
>
>
> Thx for the quick response...
>
> Here's my connecti
Sylvain Hamel <[EMAIL PROTECTED]>; MySQL Mailing list
<[EMAIL PROTECTED]>
Sent: Friday, October 05, 2001 5:07 PM
Subject: RE: DSN-Less connections using MyODBC?
> Hi !!!
>
> > -Original Message-
> > From: Sylvain Hamel [mailto:[EMAIL PROTECTED]]
> > Sen
Hi !!!
> -Original Message-
> From: Sylvain Hamel [mailto:[EMAIL PROTECTED]]
> Sent: Friday, October 05, 2001 1:36 PM
> To: MySQL Mailing list
> Subject: DSN-Less connections using MyODBC?
>
>
> Anyone ever tried a MySQL dsn-less connection (I am working
&g
Anyone ever tried a MySQL dsn-less connection (I am working in Borland C++
Builder)?
I can do it with a dsn but can't seem to make connection in dsn less.
-
Before posting, please check:
http://www.mysql.com/manua
)-Original Message-
)From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, September 05, 2001 5:35 AM
)To: [EMAIL PROTECTED]
)Cc: [EMAIL PROTECTED]
)Subject: Re: DSN-Less connection Strange error!
)
)
)[EMAIL PROTECTED] writes:
)> Hi People,
)>
)> I'm try
[EMAIL PROTECTED] writes:
> Hi People,
>
> I'm trying to connect to Mysql server using Access2k, VBA and DSN less
> connection, and mysql v3.23.36.
>
> All queries sent to the server exceute or returns records just fine except
> one simple query.
>
&
Hi People,
I'm trying to connect to Mysql server using Access2k, VBA and DSN less
connection, and mysql v3.23.36.
All queries sent to the server exceute or returns records just fine except
one simple query.
"DESCRIBE Employees" Employees is a table in my database. the ser
Hi People,
I'm trying to connect to Mysql server using Access2k, VBA and DSN less
connection, and mysql v3.23.36.
All queries sent to the server exceute or returns records just fine except
one simple query.
"DESCRIBE Employees" Employees is a table in my database. the ser
uccessfully");
SD> mysql_select_db ("test")
SD> or die ("Could not select database");
I think you need to use mysql_connect("localhost", "mysql_login", "mysql_password");
cause mySQL_test doesn't look like normal DNS record.
SD> In
sql_select_db ("test")
or die ("Could not select database");
I get the error message:
Warning: Unknown MySQL Server Host 'mySQL_test' (2) in
C:\Inetpub\wwwroot/mySQL.php on line 9
In my ODBC sources I have a user DSN of
name: mySQLtest
driver: mySQL
mySQL h
When you create user DSN, it's created in Windows Registry, so there is no
file. You can access that DSN from any application which use ODBC drivers.
--
Martin Jeremic
[EMAIL PROTECTED]
http://solair.eunet.yu/~martinj/
http://jsoft.webjum
- Original Message -
From: "David Rickerl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 22, 2001 2:57 PM
Subject: MYODBC & DSN creation
> Have successfully installed MYODBC, driver shows up in Windows Control
> Panel,
I assume that you
Have successfully installed MYODBC, driver shows up in Windows Control
Panel,
and when I try to add a new User DSN the setup screen appears. I add the
info
as outlined in the Mysql manual for 3.23.39 and everything appears ok, but
I can't find the DSN when I want to connect to Mysql. Did a
HN> How can I set a datasource name (DSN) for a database in MySQL?
Get MyODBC for the platform where you want the DSN available, then
enter the MySQL server & database details for a "machine DSN" using
your ODBC administration facilities on the platform where you want the
DS
To whom it may concern,
How can I set a datasource name (DSN) for a database in MySQL?
Thank you,
Ha
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Dear Sir, Re:MySQL Database - DSN
How to create a DSN for MYSQL DATABSE on online LINUX
server.
Pl provide me the syntax.
And also I need the syntax for FOREIGN KEY with references
to access two tables in MYSQL.
for eg. (A) Table name : Parent (column name is PARTY varchar(10
Actually I got "A connection could not be made using the data source parameters
entered. Save non-verified file DSN?
"(Mr) Pekka Gaiser" wrote:
> Hi,
> I got no solution, just a few ideas, probably you have checked them already.
> - Windows DSN name doesn't matt
64 matches
Mail list logo
