1 Replies - 828 Views - Last Post: 08 August 2018 - 09:04 AM Rate Topic: -----

#1 anjalivk10   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 03-August 18

vb6 connection string with Mysql web database

Posted 08 August 2018 - 08:06 AM

I created mysql datafile on web and wrote the connection string for vb6
I want the connection string without DSN
The connection string as follows

dim strconnect as string
strconnect="DRIVER={MySQL ODBC 3.51 Driver};Server=123.123.123.123;Port=3306;Database=test;Uid=abc;Pwd=abc123"
dataenvironment.connection1.connectionstring=strconnect
if  dataenvironment.connection1.state=0 the   dataenvironment.connection1.open

:code:
After executing the program displayed error.

Run-time-error '2147467259(80004005)
[Microsoft][ODBC Driver Manager]Data Source Name not found and no default driver specified

How to solve this error, what is missing
Please help
Thanks

This post has been edited by modi123_1: 08 August 2018 - 09:03 AM
Reason for edit:: In the future, please highlight the text that is code and click the [code] button in the editor.


Is This A Good Question/Topic? 0
  • +

Replies To: vb6 connection string with Mysql web database

#2 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15308
  • View blog
  • Posts: 61,390
  • Joined: 12-June 08

Re: vb6 connection string with Mysql web database

Posted 08 August 2018 - 09:04 AM

Unless you app is running on the network the server is on, I would recommend having a web service to interact with instead of trying to punch an insecure hole in from the web.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1