I have two computers networked together and I need to connect to the SQL database on the other computer. I can connect just fine using SQL anywhere, but when I use the connection string in my software I get an error that says "The OLEDB provider is not registered on the local machine".
I have remote access to the computer, this should only take 10 minutes for someone who knows what they're doing.
Thank you
Hi,
I'd like to help you out. Which database are you using? Also, what is the environment you are trying to connect from (.NET, Java, PHP)?
Kind Regards,
Vladan Stojanović
Dear Sir,
I am clear with your need. But I need below details:
1) What is the Software you are using in the first computer?
This is important because, there are numerous ways to establish connection.
If it is a .net application, you may not require Sql Anywhere at all.
2) Is the first computer a 64-bit/32-bit OS?
This is important because the driver required to establish a connection to the server must be installed in the client machine
Note:
I am new to freelancer but have enough experience working with different desktop applications connecting to variety of Databases ranging from Sql server to Oracle/Sybase..etc