Vba support

€8-30 EUR

Concluído

Publicado

há quase 3 anos

€8-30 EUR

Pago na entrega

Hello, I'm usign a Vba script in order to get data from SQL server, and used locally it working but when I'm using remote link doesn't'. This is the scrip Sub getDataComplessivoMagPg() Dim sConnString As String Set conn = CreateObject("[login to view URL]") Set rs = CreateObject("[login to view URL]") Server_Name = "2.122.427.112:14330" Database_Name = "mydb" User_ID = "admin" Password = "admin 1243" ' Create the connection string. sConnString = "Provider=SQLOLEDB;Data Source=" & Server_Name & ";Network Library=DBMSSOCN;Initial Catalog=" & Database_Name & ";User Id=" & User_ID & ";Password=" & Password & "" ' Open the connection and execute. [login to view URL] sConnString SQLStr = "SELECT * FROM customer_table" Set rs = [login to view URL](SQLStr) ' Set formula calculation Manual [login to view URL] = xlManual ' Check we have data. If Not [login to view URL] Then Sheets("ArcaMag").Range("O1:T10000") = "" ' Transfer result. Sheets("ArcaMag").Range("O1").CopyFromRecordset rs ' Close the recordset [login to view URL] Else MsgBox "Error: No records returned.", vbCritical End If ' Clean up If CBool([login to view URL] And adStateOpen) Then [login to view URL] Set conn = Nothing Set rs = Nothing 'MsgBox "Done!", vbInformation, "Done!" End Sub

Visual Basic

Excel

Microsoft SQL Server

ID do Projeto: 30281426

Sobre o projeto

19 propostas

Projeto remoto

Ativo há 3 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@tandat010280

Dear, If you can connect locally, I do not think this issue is from your code, please troubleshoot something on SQL server as [login to view URL]:~:text=Connect%20to%20your%20server%20and,is%20checked%20and%20click%20OK. Cheers, Dat Tan

€8 EUR em 1 dia

0,0

(0 avaliações)

0,0

19 freelancers estão ofertando em média €27 EUR for esse trabalho

@sumon355

Hello, As an expert in ms sql server and having sound knowledge in working with VBA, I am very much interested to fix the issue you are having in connecting remote sql server. Looking forward to have a positive response from you. Thanks

€30 EUR em 1 dia

5,0

(300 avaliações)

7,8

@tutulsoft

Hi, it is not issue with your Script , VBA script is okay ... need some configuration at your windows , then you can connect remote sql server with this vba script

€30 EUR em 1 dia

4,9

(27 avaliações)

5,5

@fchorley99

Hello, I see so much nonsense for 20 seconds of effort. Che palle. Use a comma, not a colon for the port. That was 10 seconds.

€10 EUR em 7 dias

4,9

(5 avaliações)

4,3

@Ahzakaria

I’m working on the same sql database structure and I faced this issue many time for the clients and I need to know the error message

€10 EUR em 1 dia

4,9

(2 avaliações)

2,6

@arunodaya123

HI, Hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects, I has done tons of projects on AQL ADODB connections using VBA. I can solve your issue. I can give my full effort to deliver this project in on time with 100% quality and accuracy. I am waiting for your kind response.

€20 EUR em 1 dia

5,0

(5 avaliações)

2,5

@bizmanas

HI I have 15 years experience in Microsoft SQL Server Database Development, Postgres Development, MYSQL Database Development, C#, Python and PowerBI I would be able to help you with the project. Please ping me offline to discuss further

€80 EUR em 7 dias

5,0

(2 avaliações)

1,5

@RenMhy

I have sufficient experience working with VB6 and since it is what VBA is using then I think I can help you on this. Besides you said it is working locally yet.

€8 EUR em 1 dia

4,6

(2 avaliações)

0,9

@niarfedevelop

Hello, best regards, currently I have more than 15 years of experience working with VB connecting it with any database management system (SQL SERVER, MYSQL, MARIADB, POSTGRESQL, ACCESS).

€25 EUR em 2 dias

5,0

(1 avaliação)

1,0

@Ayush2425

I have a great experience in this field and i am hard working and my certificate issued by the govt. of India . I am interested in these project. If you hire me, you will get many services at one time investment. I am very much confident of our succession together as I am punctual and creative. I look forward to hear from you soon. Thank you.

€19 EUR em 7 dias

0,0

(0 avaliações)

0,0

@Irtazarao49

hey i can help you to connect your db i read your code i can also look for the problem and sort it out . im full stack developer so please hand over me the task so we will sort it out !

€29 EUR em 1 dia

5,0

(1 avaliação)

0,0

@rohitnayakn2

I have been working with this skills for less thena year and are skills learning. I am beginner in this skills.I will do you a good job in the shortest possible time.

€20 EUR em 7 dias

0,0

(0 avaliações)

0,0

@torsaab994

Hi How are you?. I hope you are fine. My name Satpal Singh. I read your project detail your coding is right but this is not work when you use it. I can slove your problem. I have knowledge of VBA. So discuss about this project in chat with me.

€17 EUR em 2 dias

0,0

(0 avaliações)

0,0

@daveroberts007

Hello there, I think I can see what is wrong with your script. Please accept my proposal and I will explain to you what you need to change. If what I think is wrong with it we can work together to establish the problem. I have years of experience supporting SQL installations and the various software clients that connect to them.

€20 EUR em 1 dia

0,0

(0 avaliações)

0,0

@ajmalganii

I have been working in MS SQL for 6 years, Please let me know your requirements I can help you. I have been working in VBA for 6 years, Please let me know your requirements I can help you.

€25 EUR em 7 dias