troubled soul

[coward]

Ok, well you're probably all gonna hate me but...

 

I cant access my database as I dont know the connection string I should be using. I have looked everywhere for a provider, or driver, or anything to try and get to the database.

 

Now the reason you will hate me :

 

I installed my mysql database using phpdev. D:

Connecting through php embedded code is simple as - but i am new to vb - so dont know where to find the information required for my connection string. I understand how all the connection side of things works, and understand vb coding principles due to my experience with other languages, so just paste something nice and I will work it out :)

 

hope someone can help poor wittle me D:

[hemenkap]

hi ,

 

i think you must be having the ODBC drivers for the database you are using. you can find it out by going to control panel " ODBC datasources" here you will have the list of available drivers to choose from and i think you can locate that at least.

 

Then using that driver areate a user/system DSN and use that dsn name simply as a connection string. it will work.

 

however Odbc Class librayr is not shipped with VS .NEt and you need to download it frm the net. just search for "ODBC Drivers for .NET" at google and you will be abel to locate it.

 

rest all is same as for sql/olebd with some minor differences here and there.

[Derek Stone]

http://www.mysql.com/articles/dotnet/

[coward]

would ya look at that :)

 

cheers for the info hemenkap - all the details are there :)

 

and Derek, I shall be reading through those articles too :p